/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50617
 Source Host           : localhost
 Source Database       : jz

 Target Server Type    : MySQL
 Target Server Version : 50617
 File Encoding         : utf-8

 Date: 04/26/2015 18:51:02 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `ks_account`
-- ----------------------------
DROP TABLE IF EXISTS `ks_account`;
CREATE TABLE `ks_account` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT '记录唯一标识',
  `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '会员ID',
  `currency_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '币种ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '帐户名称',
  `balance` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '余额',
  `type` enum('cash','bank','credit','elec','other') NOT NULL DEFAULT 'cash' COMMENT '帐户类型',
  `bank` varchar(30) NOT NULL DEFAULT '' COMMENT '银行',
  `icon` varchar(30) NOT NULL DEFAULT 'default' COMMENT '银行图标',
  `billdate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '信用卡账单日',
  `repaydate` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '信用卡还款日',
  `memo` varchar(250) NOT NULL DEFAULT '' COMMENT '说明',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `system` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是系统默认帐户',
  `createtime` int(10) NOT NULL DEFAULT '0' COMMENT '添加时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录修改时间',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='账户表';

-- ----------------------------
--  Records of `ks_account`
-- ----------------------------
BEGIN;
INSERT INTO `ks_account` VALUES ('11', 'f8ecad5c-28b1-4081-9f7b-4afbaa1a2e70', '18', '0', '我的钱包', '7544.00', 'cash', '', 'default', '0', '0', '', '0', '0', '2147483647', '4294967295', '1'), ('12', '3622a63b-3f0a-4f80-9190-8a78eee7a267', '18', '0', '中国银行1234', '15000.00', 'bank', '', 'default', '0', '0', '', '0', '0', '2147483647', '4294967295', '1'), ('13', '209c6f38-46f2-4a97-9d78-18a60d5f041d', '20', '0', '我的现金', '4268.00', 'cash', '', 'default', '0', '0', '', '0', '0', '2147483647', '4294967295', '1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_account_log`
-- ----------------------------
DROP TABLE IF EXISTS `ks_account_log`;
CREATE TABLE `ks_account_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录主键',
  `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT '记录唯一标识',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `account_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '账户ID',
  `amount` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `balance` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '账户余额',
  `memo` varchar(250) NOT NULL DEFAULT '' COMMENT '说明',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录添加时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=59 DEFAULT CHARSET=utf8 COMMENT='账目流水日志表';

-- ----------------------------
--  Records of `ks_account_log`
-- ----------------------------
BEGIN;
INSERT INTO `ks_account_log` VALUES ('35', '', '18', '11', '10000.00', '10000.00', '建立账户[我的钱包],ID[11]', '1375286146'), ('36', '', '18', '11', '-10.00', '9990.00', '新增记账[早餐],ID[84],类型[expense],类别[32]', '1375286173'), ('37', '', '18', '11', '-15.00', '9975.00', '新增记账[],ID[85],类型[expense],类别[36]', '1375286188'), ('38', '', '18', '11', '-30.00', '9945.00', '新增记账[],ID[86],类型[expense],类别[44]', '1375286203'), ('39', '', '18', '11', '-50.00', '9895.00', '新增记账[外套],ID[87],类型[expense],类别[26]', '1375286254'), ('40', '', '18', '11', '-700.00', '9195.00', '新增记账[],ID[88],类型[expense],类别[42]', '1375286277'), ('41', '', '18', '12', '10000.00', '10000.00', '建立账户[中国银行1234],ID[12]', '1375286351'), ('42', '', '18', '12', '5000.00', '15000.00', '新增记账[上月工资],ID[89],类型[income],类别[7]', '1375286362'), ('43', '', '18', '11', '-20.00', '9175.00', '新增记账[],ID[90],类型[expense],类别[28]', '1375286590'), ('44', '', '18', '11', '-15.00', '9160.00', '新增记账[],ID[91],类型[expense],类别[32]', '1375286599'), ('45', '', '18', '11', '-20.00', '9140.00', '新增记账[],ID[92],类型[expense],类别[39]', '1375286608'), ('46', '', '18', '11', '-750.00', '8390.00', '新增记账[],ID[93],类型[expense],类别[42]', '1375286619'), ('47', '', '18', '11', '-45.00', '8345.00', '新增记账[],ID[94],类型[expense],类别[47]', '1375286639'), ('48', '', '18', '11', '0.00', '8345.00', '编辑记账[房租],ID[1]', '1375286684'), ('49', '', '18', '11', '0.00', '8345.00', '编辑记账[苹果和梨],ID[1]', '1375286693'), ('50', '', '18', '11', '0.00', '8345.00', '编辑记账[午餐],ID[1]', '1375286700'), ('51', '', '20', '13', '5000.00', '5000.00', '建立账户[我的现金],ID[13]', '1375286911'), ('52', '', '20', '13', '-24.00', '4976.00', '新增记账[],ID[95],类型[expense],类别[179]', '1375286919'), ('53', '', '20', '13', '-200.00', '4776.00', '新增记账[],ID[96],类型[expense],类别[205]', '1375286931'), ('54', '', '20', '13', '-8.00', '4768.00', '新增记账[],ID[97],类型[expense],类别[192]', '1375286951'), ('55', '', '20', '13', '-500.00', '4268.00', '新增记账[交房租咯。],ID[98],类型[expense],类别[188]', '1375286965'), ('56', '', '18', '11', '-35.00', '8310.00', '新增记账[],ID[99],类型[expense],类别[26]', '1425697007'), ('57', '', '18', '11', '-322.00', '7988.00', '新增记账[fsdfdasfad],ID[100],类型[expense],类别[26]', '1425697013'), ('58', '', '18', '11', '-444.00', '7544.00', '新增记账[],ID[101],类型[expense],类别[31]', '1425697038');
COMMIT;

-- ----------------------------
--  Table structure for `ks_admin`
-- ----------------------------
DROP TABLE IF EXISTS `ks_admin`;
CREATE TABLE `ks_admin` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(30) NOT NULL COMMENT '用户名',
  `password` varchar(32) NOT NULL COMMENT '密码',
  `sex` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `createtime` int(10) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `logintime` int(10) NOT NULL DEFAULT '0' COMMENT '加入时间',
  `loginfailure` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '登录失败次数',
  `sessionid` varchar(100) NOT NULL DEFAULT '',
  `pagesize` int(10) unsigned NOT NULL DEFAULT '25' COMMENT '分页大小',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=71830690 DEFAULT CHARSET=utf8 COMMENT='管理员表';

-- ----------------------------
--  Records of `ks_admin`
-- ----------------------------
BEGIN;
INSERT INTO `ks_admin` VALUES ('71830689', '1', 'karson', 'e10adc3949ba59abbe56e057f20f883e', '1', '1362193445', '1430044692', '0', 'jbv22rsst0vukuptfen913sl10', '25');
COMMIT;

-- ----------------------------
--  Table structure for `ks_admin_log`
-- ----------------------------
DROP TABLE IF EXISTS `ks_admin_log`;
CREATE TABLE `ks_admin_log` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '管理员名字',
  `url` varchar(100) NOT NULL,
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '日志标题',
  `content` text NOT NULL COMMENT '内容',
  `createtime` int(10) NOT NULL COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `name` (`name`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=4196 DEFAULT CHARSET=utf8 COMMENT='管理员操作日志表';

-- ----------------------------
--  Records of `ks_admin_log`
-- ----------------------------
BEGIN;
INSERT INTO `ks_admin_log` VALUES ('4153', '', '/admin/index/login', '登录后台失败[error:密码错误]', '', '1373787187'), ('4154', 'karson', '/admin/index/login', '成功登录后台[id:71830689-c2e6-43b1-a3fe-b9dcaf5d8662]', '', '1373787195'), ('4155', 'karson', '/admin/index/login', '成功登录后台[id:71830689-c2e6-43b1-a3fe-b9dcaf5d8662]', '', '1373787240'), ('4156', 'karson', '/admin/index/login', '成功登录后台[id:71830689-c2e6-43b1-a3fe-b9dcaf5d8662]', '', '1373787248'), ('4157', 'karson', '/admin/index/login', '成功登录后台[id:71830689-c2e6-43b1-a3fe-b9dcaf5d8662]', '', '1373787269'), ('4158', 'karson', '/admin/index/login', '成功登录后台[id:71830689-c2e6-43b1-a3fe-b9dcaf5d8662]', '', '1373787334'), ('4159', 'karson', '/admin/index/login', '成功登录后台[id:71830689-c2e6-43b1-a3fe-b9dcaf5d8662]', '', '1373787357'), ('4160', '', '/admin/index/login', '登录后台失败[error:权限读取出错,请与超级管理员联系]', '', '1373812794'), ('4161', '', '/admin/index/login', '登录后台失败[error:权限读取出错,请与超级管理员联系]', '', '1373812794'), ('4162', '', '/admin/index/login', '登录后台失败[error:权限读取出错,请与超级管理员联系]', '', '1373812807'), ('4163', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374071071'), ('4164', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374071096'), ('4165', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374071102'), ('4166', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374071102'), ('4167', '', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374071168'), ('4168', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374071175'), ('4169', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374072973'), ('4170', 'karson', '/admin/general/logs/clearlog', '删除日志[2013-07-17]', '', '1374074051'), ('4171', 'karson', '/admin/general/logs/clearlog', '删除日志[2013-07-17]', '', '1374074056'), ('4172', 'karson', '/admin/general/logs/clearlog', '删除日志[2013-07-17]', '', '1374074103'), ('4173', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":[],\"after\":{\"error_log\":\"true\"}}', '1374074157'), ('4174', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":[],\"after\":{\"error_log\":\"true\"}}', '1374074256'), ('4175', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":[],\"after\":{\"error_log\":\"true\"}}', '1374074259'), ('4176', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":[],\"after\":{\"error_log\":\"true\"}}', '1374074266'), ('4177', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":[],\"after\":{\"error_log\":\"true\"}}', '1374074296'), ('4178', 'karson', '/admin/general/logs/clearlog', '删除日志[2013-07-17]', '', '1374074840'), ('4179', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":[],\"after\":{\"error_log\":\"true\"}}', '1374075530'), ('4180', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":{\"version\":\"2.0.0\"},\"after\":{\"error_log\":\"true\",\"version\":\"2.0.01\"}}', '1374075867'), ('4181', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374421988'), ('4182', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1374421988'), ('4183', 'karson', '/admin/general/logs/clearlog', '删除日志[2013-07-21]', '', '1374422049'), ('4184', 'karson', '/admin/general/config/edit', '修改系统配置', '{\"before\":[],\"after\":{\"error_log\":\"true\",\"email_confirm\":\"false\"}}', '1374502528'), ('4185', 'karson', '/admin/general/logs/clearlog', '删除日志[2013-07-22]', '', '1374502575'), ('4186', 'karson', '/admin/general/logs/clearlog', '删除日志[2013-07-22]', '', '1374504560'), ('4187', '', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1425697283'), ('4188', '', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1425697606'), ('4189', '', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1425697647'), ('4190', '', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1425697655'), ('4191', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1425697791'), ('4192', 'karson', '/admin/general/logs/clearlog', '删除日志[2015-03-07]', '', '1425719643'), ('4193', '', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1430044627'), ('4194', '', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1430044634'), ('4195', 'karson', '/admin/index/login', '非后台管理用户不能登录,请联系管理人员处理', '', '1430044692');
COMMIT;

-- ----------------------------
--  Table structure for `ks_bank`
-- ----------------------------
DROP TABLE IF EXISTS `ks_bank`;
CREATE TABLE `ks_bank` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '银行名称',
  `pinyin` varchar(30) NOT NULL DEFAULT '' COMMENT '银行拼音',
  `icon` varchar(30) NOT NULL DEFAULT 'default' COMMENT '银行图标',
  `website` varchar(100) NOT NULL COMMENT '银行官网',
  `telephone` varchar(30) NOT NULL COMMENT '银行客服电话',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='账户表';

-- ----------------------------
--  Records of `ks_bank`
-- ----------------------------
BEGIN;
INSERT INTO `ks_bank` VALUES ('1', '中国银行', '', 'default', '', '', '0', '1'), ('4', '中国工商银行', '', 'gonghang', '', '', '0', '1'), ('15', '中国农业银行', '', 'default', '', '', '0', '1'), ('16', '中国建设银行', '', 'nonghang', '', '', '0', '1'), ('17', '中国交通银行', '', 'zhaohang', '', '', '0', '1'), ('18', '中国民生银行', '', 'sf', '', '', '0', '1'), ('20', '其它银行', '', 'default', '', '', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_bill`
-- ----------------------------
DROP TABLE IF EXISTS `ks_bill`;
CREATE TABLE `ks_bill` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录主键',
  `father_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父的流水记录ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `task_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '自动记账ID',
  `type` enum('income','expense','transfer','borrow','credit') NOT NULL DEFAULT 'expense' COMMENT '类型',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID,1,2,3,4分别为借出,借入,还入,还出',
  `account_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作账户ID',
  `inaccount_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收入账户ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '消费名称',
  `amount` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `outstanding` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '未结清的账目,只针对type=borrow有效',
  `memo` varchar(250) NOT NULL DEFAULT '' COMMENT '说明',
  `family` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '家庭组是否可以查看',
  `borrowtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '还款日期(只对type=borrow有效)',
  `occurtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '消费发生时间',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录添加时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录修改时间',
  `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT '记录唯一标识',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`account_id`,`category_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COMMENT='账目表';

-- ----------------------------
--  Records of `ks_bill`
-- ----------------------------
BEGIN;
INSERT INTO `ks_bill` VALUES ('84', '0', '18', '0', 'expense', '32', '11', '0', '', '10.00', '0.00', '早餐', '1', '0', '1375200000', '1375286172', '0', ''), ('85', '0', '18', '0', 'expense', '36', '11', '0', '', '15.00', '0.00', '', '1', '0', '1375200000', '1375286188', '0', ''), ('86', '0', '18', '0', 'expense', '44', '11', '0', '', '30.00', '0.00', '', '1', '0', '1375200000', '1375286203', '0', ''), ('87', '0', '18', '0', 'expense', '26', '11', '0', '', '50.00', '0.00', '外套', '1', '0', '1375200000', '1375286253', '0', ''), ('88', '0', '18', '0', 'expense', '42', '11', '0', '', '700.00', '0.00', '', '1', '0', '1375200000', '1375286277', '0', ''), ('89', '0', '18', '0', 'income', '7', '12', '0', '', '5000.00', '0.00', '上月工资', '1', '0', '1375200000', '1375286362', '0', ''), ('90', '0', '18', '0', 'expense', '28', '11', '0', '', '20.00', '0.00', '', '1', '0', '1375286400', '1375286590', '0', ''), ('91', '0', '18', '0', 'expense', '32', '11', '0', '', '15.00', '0.00', '午餐', '1', '0', '1375286400', '1375286599', '0', ''), ('92', '0', '18', '0', 'expense', '39', '11', '0', '', '20.00', '0.00', '苹果和梨', '1', '0', '1375286400', '1375286607', '0', ''), ('93', '0', '18', '0', 'expense', '42', '11', '0', '', '750.00', '0.00', '房租', '1', '0', '1375286400', '1375286619', '0', ''), ('94', '0', '18', '0', 'expense', '47', '11', '0', '', '45.00', '0.00', '', '1', '0', '1375286400', '1375286639', '0', ''), ('95', '0', '20', '0', 'expense', '179', '13', '0', '', '24.00', '0.00', '', '1', '0', '1375286400', '1375286919', '0', ''), ('96', '0', '20', '0', 'expense', '205', '13', '0', '', '200.00', '0.00', '', '1', '0', '1375286400', '1375286930', '0', ''), ('97', '0', '20', '0', 'expense', '192', '13', '0', '', '8.00', '0.00', '', '1', '0', '1375286400', '1375286951', '0', ''), ('98', '0', '20', '0', 'expense', '188', '13', '0', '', '500.00', '0.00', '交房租咯。', '1', '0', '1375286400', '1375286965', '0', ''), ('99', '0', '18', '0', 'expense', '26', '11', '0', '', '35.00', '0.00', '', '1', '0', '1425657600', '1425697007', '0', ''), ('100', '0', '18', '0', 'expense', '26', '11', '0', '', '322.00', '0.00', 'fsdfdasfad', '1', '0', '1425657600', '1425697013', '0', ''), ('101', '0', '18', '0', 'expense', '31', '11', '0', '', '444.00', '0.00', '', '1', '0', '1425657600', '1425697038', '0', '');
COMMIT;

-- ----------------------------
--  Table structure for `ks_budget`
-- ----------------------------
DROP TABLE IF EXISTS `ks_budget`;
CREATE TABLE `ks_budget` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT '记录唯一标识',
  `user_id` int(10) unsigned NOT NULL COMMENT '会员ID',
  `year` int(10) unsigned NOT NULL DEFAULT '2012' COMMENT '年',
  `month` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '月',
  `content` varchar(250) NOT NULL COMMENT '预算数据',
  `createtime` int(10) NOT NULL COMMENT '创建时间',
  `state` tinyint(1) NOT NULL COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='预算表';

-- ----------------------------
--  Records of `ks_budget`
-- ----------------------------
BEGIN;
INSERT INTO `ks_budget` VALUES ('5', '640b9fb8-abb3-4be8-a81b-8aefd00c5a24', '18', '2013', '7', '{\"expense\":{\"18\":\"100\",\"19\":\"200\",\"20\":\"600\",\"21\":\"100\",\"23\":\"100\",\"24\":\"0\",\"25\":\"100\",\"22\":\"0\"}}', '2147483647', '1'), ('6', '968cdac7-533d-4084-ac99-274f097a2793', '18', '2013', '8', '{\"expense\":{\"18\":\"100\",\"19\":\"200\",\"20\":\"600\",\"21\":\"100\",\"23\":\"100\",\"24\":\"0\",\"25\":\"100\",\"22\":\"0\"}}', '2147483647', '0'), ('7', 'ed20b877-3999-4aed-9c71-e9d84d2be29b', '20', '2013', '8', '{\"expense\":{\"164\":\"200\",\"165\":\"100\",\"166\":\"600\",\"167\":\"40\",\"169\":\"200\",\"170\":\"0\",\"171\":\"0\",\"168\":\"0\"}}', '2147483647', '0');
COMMIT;

-- ----------------------------
--  Table structure for `ks_category`
-- ----------------------------
DROP TABLE IF EXISTS `ks_category`;
CREATE TABLE `ks_category` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT '记录唯一标识',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '玩家ID',
  `father_id` int(10) NOT NULL COMMENT '父分类',
  `name` varchar(30) NOT NULL COMMENT '分类名称',
  `type` enum('income','expense','transfer','borrow','bbs','diary') NOT NULL DEFAULT 'expense' COMMENT '分类类型',
  `system` tinyint(1) NOT NULL DEFAULT '0' COMMENT '是否为系统类别',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '排序权重',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录修改时间',
  `state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=223 DEFAULT CHARSET=utf8 COMMENT='分类表';

-- ----------------------------
--  Records of `ks_category`
-- ----------------------------
BEGIN;
INSERT INTO `ks_category` VALUES ('1', '', '0', '0', '理财经验', 'bbs', '1', '0', '0', '0', '1'), ('2', '', '0', '0', '酱友灌水', 'bbs', '1', '0', '0', '0', '1'), ('3', '', '0', '0', '意见建议', 'bbs', '1', '0', '0', '0', '1'), ('4', '', '18', '0', '薪资', 'income', '1', '1', '1375286064', '1375286064', '1'), ('5', '', '18', '0', '投资', 'income', '1', '1', '1375286064', '1375286064', '1'), ('6', '', '18', '0', '其它', 'income', '1', '1', '1375286064', '1375286064', '1'), ('7', '', '18', '4', '公司工资', 'income', '1', '1', '1375286064', '1375286064', '1'), ('8', '', '18', '4', 'SOHO接单', 'income', '1', '2', '1375286064', '1375286064', '1'), ('9', '', '18', '4', '加班收入', 'income', '1', '3', '1375286064', '1375286064', '1'), ('10', '', '18', '4', '奖金', 'income', '1', '4', '1375286064', '1375286064', '1'), ('11', '', '18', '5', '股票', 'income', '1', '1', '1375286064', '1375286064', '1'), ('12', '', '18', '5', '基金', 'income', '1', '2', '1375286064', '1375286064', '1'), ('13', '', '18', '5', '分红', 'income', '1', '3', '1375286064', '1375286064', '1'), ('14', '', '18', '5', '利息', 'income', '1', '4', '1375286064', '1375286064', '1'), ('15', '', '18', '6', '发票中奖', 'income', '1', '1', '1375286064', '1375286064', '1'), ('16', '', '18', '6', '博彩收入', 'income', '1', '2', '1375286064', '1375286064', '1'), ('17', '', '18', '6', '其它', 'income', '1', '3', '1375286064', '1375286064', '1'), ('18', '', '18', '0', '衣', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('19', '', '18', '0', '食', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('20', '', '18', '0', '住', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('21', '', '18', '0', '行', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('22', '', '18', '0', '教育', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('23', '', '18', '0', '娱乐', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('24', '', '18', '0', '医疗', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('25', '', '18', '0', '其它', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('26', '', '18', '18', '购衣费', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('27', '', '18', '18', '化妆品', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('28', '', '18', '18', '洗衣费用', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('29', '', '18', '18', '箱包', 'expense', '1', '4', '1375286064', '1375286064', '1'), ('30', '', '18', '18', '饰品', 'expense', '1', '5', '1375286064', '1375286064', '1'), ('31', '', '18', '19', '外出就餐', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('32', '', '18', '19', '工作餐', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('33', '', '18', '19', '买菜', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('34', '', '18', '19', '柴米油盐', 'expense', '1', '4', '1375286064', '1375286064', '1'), ('35', '', '18', '19', '外卖', 'expense', '1', '5', '1375286064', '1375286064', '1'), ('36', '', '18', '19', '零售', 'expense', '1', '6', '1375286064', '1375286064', '1'), ('37', '', '18', '19', '小吃', 'expense', '1', '7', '1375286064', '1375286064', '1'), ('38', '', '18', '19', '饮料', 'expense', '1', '8', '1375286064', '1375286064', '1'), ('39', '', '18', '19', '水果', 'expense', '1', '9', '1375286064', '1375286064', '1'), ('40', '', '18', '19', '烟酒茶', 'expense', '1', '10', '1375286064', '1375286064', '1'), ('41', '', '18', '20', '水电气费', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('42', '', '18', '20', '房租', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('43', '', '18', '20', '物业费', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('44', '', '18', '21', '停车费', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('45', '', '18', '21', '汽油费用', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('46', '', '18', '21', '公共交通', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('47', '', '18', '21', '的士费用', 'expense', '1', '4', '1375286064', '1375286064', '1'), ('48', '', '18', '21', '汽车保养', 'expense', '1', '5', '1375286064', '1375286064', '1'), ('49', '', '18', '21', '过路费', 'expense', '1', '6', '1375286064', '1375286064', '1'), ('50', '', '18', '21', '年检保险', 'expense', '1', '7', '1375286064', '1375286064', '1'), ('51', '', '18', '21', '违章罚款', 'expense', '1', '8', '1375286064', '1375286064', '1'), ('52', '', '18', '21', '汽车修理', 'expense', '1', '9', '1375286064', '1375286064', '1'), ('53', '', '18', '22', '书籍杂志', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('54', '', '18', '22', '文具费用', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('55', '', '18', '22', '考试费用', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('56', '', '18', '22', '培训费用', 'expense', '1', '4', '1375286064', '1375286064', '1'), ('57', '', '18', '22', '学杂费用', 'expense', '1', '5', '1375286064', '1375286064', '1'), ('58', '', '18', '23', '旅游度假', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('59', '', '18', '23', '休闲放松', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('60', '', '18', '23', '博彩支出', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('61', '', '18', '23', '健身运动', 'expense', '1', '4', '1375286064', '1375286064', '1'), ('62', '', '18', '23', '宠物饲养', 'expense', '1', '5', '1375286064', '1375286064', '1'), ('63', '', '18', '24', '诊疗费', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('64', '', '18', '24', '药品费', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('65', '', '18', '24', '健康食品', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('66', '', '18', '25', '话费', 'expense', '1', '1', '1375286064', '1375286064', '1'), ('67', '', '18', '25', '网费', 'expense', '1', '2', '1375286064', '1375286064', '1'), ('68', '', '18', '25', '电器用品', 'expense', '1', '3', '1375286064', '1375286064', '1'), ('69', '', '18', '25', '生活用品', 'expense', '1', '4', '1375286064', '1375286064', '1'), ('70', '', '18', '25', '洗衣费用', 'expense', '1', '5', '1375286064', '1375286064', '1'), ('71', '', '18', '25', '保险费用', 'expense', '1', '6', '1375286064', '1375286064', '1'), ('72', '', '18', '25', '税收费用', 'expense', '1', '7', '1375286064', '1375286064', '1'), ('73', '', '18', '25', '交际费用', 'expense', '1', '8', '1375286064', '1375286064', '1'), ('74', '', '18', '25', '孝敬长辈', 'expense', '1', '9', '1375286064', '1375286064', '1'), ('75', '', '18', '25', '捐款捐赠', 'expense', '1', '10', '1375286064', '1375286064', '1'), ('76', '', '18', '25', '坏账损失', 'expense', '1', '11', '1375286064', '1375286064', '1'), ('77', '', '19', '0', '薪资', 'income', '1', '1', '1375286455', '1375286455', '1'), ('78', '', '19', '0', '投资', 'income', '1', '1', '1375286455', '1375286455', '1'), ('79', '', '19', '0', '其它', 'income', '1', '1', '1375286455', '1375286455', '1'), ('80', '', '19', '77', '公司工资', 'income', '1', '1', '1375286455', '1375286455', '1'), ('81', '', '19', '77', 'SOHO接单', 'income', '1', '2', '1375286455', '1375286455', '1'), ('82', '', '19', '77', '加班收入', 'income', '1', '3', '1375286455', '1375286455', '1'), ('83', '', '19', '77', '奖金', 'income', '1', '4', '1375286455', '1375286455', '1'), ('84', '', '19', '78', '股票', 'income', '1', '1', '1375286455', '1375286455', '1'), ('85', '', '19', '78', '基金', 'income', '1', '2', '1375286455', '1375286455', '1'), ('86', '', '19', '78', '分红', 'income', '1', '3', '1375286455', '1375286455', '1'), ('87', '', '19', '78', '利息', 'income', '1', '4', '1375286455', '1375286455', '1'), ('88', '', '19', '79', '发票中奖', 'income', '1', '1', '1375286455', '1375286455', '1'), ('89', '', '19', '79', '博彩收入', 'income', '1', '2', '1375286455', '1375286455', '1'), ('90', '', '19', '79', '其它', 'income', '1', '3', '1375286455', '1375286455', '1'), ('91', '', '19', '0', '衣', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('92', '', '19', '0', '食', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('93', '', '19', '0', '住', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('94', '', '19', '0', '行', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('95', '', '19', '0', '教育', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('96', '', '19', '0', '娱乐', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('97', '', '19', '0', '医疗', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('98', '', '19', '0', '其它', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('99', '', '19', '91', '购衣费', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('100', '', '19', '91', '化妆品', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('101', '', '19', '91', '洗衣费用', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('102', '', '19', '91', '箱包', 'expense', '1', '4', '1375286455', '1375286455', '1'), ('103', '', '19', '91', '饰品', 'expense', '1', '5', '1375286455', '1375286455', '1'), ('104', '', '19', '92', '外出就餐', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('105', '', '19', '92', '工作餐', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('106', '', '19', '92', '买菜', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('107', '', '19', '92', '柴米油盐', 'expense', '1', '4', '1375286455', '1375286455', '1'), ('108', '', '19', '92', '外卖', 'expense', '1', '5', '1375286455', '1375286455', '1'), ('109', '', '19', '92', '零售', 'expense', '1', '6', '1375286455', '1375286455', '1'), ('110', '', '19', '92', '小吃', 'expense', '1', '7', '1375286455', '1375286455', '1'), ('111', '', '19', '92', '饮料', 'expense', '1', '8', '1375286455', '1375286455', '1'), ('112', '', '19', '92', '水果', 'expense', '1', '9', '1375286455', '1375286455', '1'), ('113', '', '19', '92', '烟酒茶', 'expense', '1', '10', '1375286455', '1375286455', '1'), ('114', '', '19', '93', '水电气费', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('115', '', '19', '93', '房租', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('116', '', '19', '93', '物业费', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('117', '', '19', '94', '停车费', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('118', '', '19', '94', '汽油费用', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('119', '', '19', '94', '公共交通', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('120', '', '19', '94', '的士费用', 'expense', '1', '4', '1375286455', '1375286455', '1'), ('121', '', '19', '94', '汽车保养', 'expense', '1', '5', '1375286455', '1375286455', '1'), ('122', '', '19', '94', '过路费', 'expense', '1', '6', '1375286455', '1375286455', '1'), ('123', '', '19', '94', '年检保险', 'expense', '1', '7', '1375286455', '1375286455', '1'), ('124', '', '19', '94', '违章罚款', 'expense', '1', '8', '1375286455', '1375286455', '1'), ('125', '', '19', '94', '汽车修理', 'expense', '1', '9', '1375286455', '1375286455', '1'), ('126', '', '19', '95', '书籍杂志', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('127', '', '19', '95', '文具费用', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('128', '', '19', '95', '考试费用', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('129', '', '19', '95', '培训费用', 'expense', '1', '4', '1375286455', '1375286455', '1'), ('130', '', '19', '95', '学杂费用', 'expense', '1', '5', '1375286455', '1375286455', '1'), ('131', '', '19', '96', '旅游度假', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('132', '', '19', '96', '休闲放松', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('133', '', '19', '96', '博彩支出', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('134', '', '19', '96', '健身运动', 'expense', '1', '4', '1375286455', '1375286455', '1'), ('135', '', '19', '96', '宠物饲养', 'expense', '1', '5', '1375286455', '1375286455', '1'), ('136', '', '19', '97', '诊疗费', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('137', '', '19', '97', '药品费', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('138', '', '19', '97', '健康食品', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('139', '', '19', '98', '话费', 'expense', '1', '1', '1375286455', '1375286455', '1'), ('140', '', '19', '98', '网费', 'expense', '1', '2', '1375286455', '1375286455', '1'), ('141', '', '19', '98', '电器用品', 'expense', '1', '3', '1375286455', '1375286455', '1'), ('142', '', '19', '98', '生活用品', 'expense', '1', '4', '1375286455', '1375286455', '1'), ('143', '', '19', '98', '洗衣费用', 'expense', '1', '5', '1375286455', '1375286455', '1'), ('144', '', '19', '98', '保险费用', 'expense', '1', '6', '1375286455', '1375286455', '1'), ('145', '', '19', '98', '税收费用', 'expense', '1', '7', '1375286455', '1375286455', '1'), ('146', '', '19', '98', '交际费用', 'expense', '1', '8', '1375286455', '1375286455', '1'), ('147', '', '19', '98', '孝敬长辈', 'expense', '1', '9', '1375286455', '1375286455', '1'), ('148', '', '19', '98', '捐款捐赠', 'expense', '1', '10', '1375286455', '1375286455', '1'), ('149', '', '19', '98', '坏账损失', 'expense', '1', '11', '1375286455', '1375286455', '1'), ('150', '', '20', '0', '薪资', 'income', '1', '1', '1375286799', '1375286799', '1'), ('151', '', '20', '0', '投资', 'income', '1', '1', '1375286799', '1375286799', '1'), ('152', '', '20', '0', '其它', 'income', '1', '1', '1375286799', '1375286799', '1'), ('153', '', '20', '150', '公司工资', 'income', '1', '1', '1375286799', '1375286799', '1'), ('154', '', '20', '150', 'SOHO接单', 'income', '1', '2', '1375286799', '1375286799', '1'), ('155', '', '20', '150', '加班收入', 'income', '1', '3', '1375286799', '1375286799', '1'), ('156', '', '20', '150', '奖金', 'income', '1', '4', '1375286799', '1375286799', '1'), ('157', '', '20', '151', '股票', 'income', '1', '1', '1375286799', '1375286799', '1'), ('158', '', '20', '151', '基金', 'income', '1', '2', '1375286799', '1375286799', '1'), ('159', '', '20', '151', '分红', 'income', '1', '3', '1375286799', '1375286799', '1'), ('160', '', '20', '151', '利息', 'income', '1', '4', '1375286799', '1375286799', '1'), ('161', '', '20', '152', '发票中奖', 'income', '1', '1', '1375286799', '1375286799', '1'), ('162', '', '20', '152', '博彩收入', 'income', '1', '2', '1375286799', '1375286799', '1'), ('163', '', '20', '152', '其它', 'income', '1', '3', '1375286799', '1375286799', '1'), ('164', '', '20', '0', '衣', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('165', '', '20', '0', '食', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('166', '', '20', '0', '住', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('167', '', '20', '0', '行', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('168', '', '20', '0', '教育', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('169', '', '20', '0', '娱乐', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('170', '', '20', '0', '医疗', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('171', '', '20', '0', '其它', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('172', '', '20', '164', '购衣费', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('173', '', '20', '164', '化妆品', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('174', '', '20', '164', '洗衣费用', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('175', '', '20', '164', '箱包', 'expense', '1', '4', '1375286799', '1375286799', '1'), ('176', '', '20', '164', '饰品', 'expense', '1', '5', '1375286799', '1375286799', '1'), ('177', '', '20', '165', '外出就餐', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('178', '', '20', '165', '工作餐', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('179', '', '20', '165', '买菜', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('180', '', '20', '165', '柴米油盐', 'expense', '1', '4', '1375286799', '1375286799', '1'), ('181', '', '20', '165', '外卖', 'expense', '1', '5', '1375286799', '1375286799', '1'), ('182', '', '20', '165', '零售', 'expense', '1', '6', '1375286799', '1375286799', '1'), ('183', '', '20', '165', '小吃', 'expense', '1', '7', '1375286799', '1375286799', '1'), ('184', '', '20', '165', '饮料', 'expense', '1', '8', '1375286799', '1375286799', '1'), ('185', '', '20', '165', '水果', 'expense', '1', '9', '1375286799', '1375286799', '1'), ('186', '', '20', '165', '烟酒茶', 'expense', '1', '10', '1375286799', '1375286799', '1'), ('187', '', '20', '166', '水电气费', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('188', '', '20', '166', '房租', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('189', '', '20', '166', '物业费', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('190', '', '20', '167', '停车费', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('191', '', '20', '167', '汽油费用', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('192', '', '20', '167', '公共交通', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('193', '', '20', '167', '的士费用', 'expense', '1', '4', '1375286799', '1375286799', '1'), ('194', '', '20', '167', '汽车保养', 'expense', '1', '5', '1375286799', '1375286799', '1'), ('195', '', '20', '167', '过路费', 'expense', '1', '6', '1375286799', '1375286799', '1'), ('196', '', '20', '167', '年检保险', 'expense', '1', '7', '1375286799', '1375286799', '1'), ('197', '', '20', '167', '违章罚款', 'expense', '1', '8', '1375286799', '1375286799', '1'), ('198', '', '20', '167', '汽车修理', 'expense', '1', '9', '1375286799', '1375286799', '1'), ('199', '', '20', '168', '书籍杂志', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('200', '', '20', '168', '文具费用', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('201', '', '20', '168', '考试费用', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('202', '', '20', '168', '培训费用', 'expense', '1', '4', '1375286799', '1375286799', '1'), ('203', '', '20', '168', '学杂费用', 'expense', '1', '5', '1375286799', '1375286799', '1'), ('204', '', '20', '169', '旅游度假', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('205', '', '20', '169', '休闲放松', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('206', '', '20', '169', '博彩支出', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('207', '', '20', '169', '健身运动', 'expense', '1', '4', '1375286799', '1375286799', '1'), ('208', '', '20', '169', '宠物饲养', 'expense', '1', '5', '1375286799', '1375286799', '1'), ('209', '', '20', '170', '诊疗费', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('210', '', '20', '170', '药品费', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('211', '', '20', '170', '健康食品', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('212', '', '20', '171', '话费', 'expense', '1', '1', '1375286799', '1375286799', '1'), ('213', '', '20', '171', '网费', 'expense', '1', '2', '1375286799', '1375286799', '1'), ('214', '', '20', '171', '电器用品', 'expense', '1', '3', '1375286799', '1375286799', '1'), ('215', '', '20', '171', '生活用品', 'expense', '1', '4', '1375286799', '1375286799', '1'), ('216', '', '20', '171', '洗衣费用', 'expense', '1', '5', '1375286799', '1375286799', '1'), ('217', '', '20', '171', '保险费用', 'expense', '1', '6', '1375286799', '1375286799', '1'), ('218', '', '20', '171', '税收费用', 'expense', '1', '7', '1375286799', '1375286799', '1'), ('219', '', '20', '171', '交际费用', 'expense', '1', '8', '1375286799', '1375286799', '1'), ('220', '', '20', '171', '孝敬长辈', 'expense', '1', '9', '1375286799', '1375286799', '1'), ('221', '', '20', '171', '捐款捐赠', 'expense', '1', '10', '1375286799', '1375286799', '1'), ('222', '', '20', '171', '坏账损失', 'expense', '1', '11', '1375286799', '1375286799', '1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_city`
-- ----------------------------
DROP TABLE IF EXISTS `ks_city`;
CREATE TABLE `ks_city` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `province_id` tinyint(1) NOT NULL DEFAULT '0',
  `sortrank` int(10) NOT NULL DEFAULT '0' COMMENT '排序',
  `name` varchar(30) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `province_id` (`province_id`),
  KEY `sortrank` (`sortrank`)
) ENGINE=MyISAM AUTO_INCREMENT=525 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `ks_city`
-- ----------------------------
BEGIN;
INSERT INTO `ks_city` VALUES ('1', '0', '0', '北京'), ('2', '0', '0', '上海'), ('3', '0', '0', '天津'), ('4', '0', '0', '重庆'), ('5', '0', '0', '黑龙江'), ('6', '0', '0', '辽宁'), ('7', '0', '0', '吉林'), ('8', '0', '0', '河北'), ('9', '0', '0', '内蒙古'), ('10', '0', '0', '陕西'), ('11', '0', '0', '山西'), ('12', '0', '0', '甘肃'), ('13', '0', '0', '宁夏'), ('14', '0', '0', '新疆'), ('15', '0', '0', '西藏'), ('16', '0', '0', '青海'), ('17', '0', '0', '四川'), ('18', '0', '0', '云南'), ('19', '0', '0', '贵州'), ('20', '0', '0', '湖南'), ('21', '0', '0', '湖北'), ('22', '0', '0', '河南'), ('23', '0', '0', '山东'), ('24', '0', '0', '安徽'), ('25', '0', '0', '江苏'), ('26', '0', '0', '浙江'), ('27', '0', '0', '台湾'), ('28', '0', '0', '香港'), ('29', '0', '0', '澳门'), ('30', '0', '0', '广东'), ('31', '0', '0', '广西'), ('32', '0', '0', '江西'), ('33', '0', '0', '福建'), ('34', '0', '0', '海南'), ('35', '0', '0', '其它'), ('36', '0', '0', '美国'), ('37', '0', '0', '欧洲'), ('38', '0', '0', '日本'), ('39', '0', '0', '韩国'), ('40', '0', '0', '新加坡'), ('41', '0', '0', '加拿大'), ('42', '0', '0', '亚　洲'), ('43', '0', '0', '非　洲'), ('44', '0', '0', '澳　洲'), ('45', '0', '0', '南美洲'), ('46', '0', '0', '东南亚'), ('47', '1', '0', '北京市'), ('48', '1', '0', '朝阳'), ('49', '1', '0', '东城'), ('50', '1', '0', '西城'), ('51', '1', '0', '海淀'), ('52', '1', '0', '丰台'), ('53', '1', '0', '崇文'), ('54', '1', '0', '宣武'), ('55', '1', '0', '通州'), ('56', '1', '0', '昌平'), ('57', '1', '0', '大兴'), ('58', '1', '0', '房山'), ('59', '1', '0', '怀柔'), ('60', '1', '0', '门头沟'), ('61', '1', '0', '密云'), ('62', '1', '0', '平谷'), ('63', '1', '0', '石景山'), ('64', '1', '0', '顺义'), ('65', '1', '0', '延庆'), ('66', '2', '0', '上海市'), ('67', '2', '0', '长宁'), ('68', '2', '0', '松江'), ('69', '2', '0', '闸北'), ('70', '2', '0', '徐汇'), ('71', '2', '0', '杨浦'), ('72', '2', '0', '青浦'), ('73', '2', '0', '崇明'), ('74', '2', '0', '奉贤'), ('75', '2', '0', '普陀'), ('76', '2', '0', '浦东'), ('77', '2', '0', '南市'), ('78', '2', '0', '虹口'), ('79', '2', '0', '南汇'), ('80', '2', '0', '闵行'), ('81', '2', '0', '黄浦'), ('82', '2', '0', '嘉定'), ('83', '2', '0', '金山'), ('84', '2', '0', '静安'), ('85', '2', '0', '卢湾'), ('86', '2', '0', '宝山'), ('87', '3', '0', '天津市'), ('88', '3', '0', '西青'), ('89', '3', '0', '武清'), ('90', '3', '0', '北辰'), ('91', '3', '0', '大港'), ('92', '3', '0', '东丽'), ('93', '3', '0', '汉沽'), ('94', '3', '0', '塘沽'), ('95', '3', '0', '和平'), ('96', '3', '0', '河北'), ('97', '3', '0', '河东'), ('98', '3', '0', '河西'), ('99', '3', '0', '红桥'), ('100', '3', '0', '蓟县'), ('101', '3', '0', '津南'), ('102', '3', '0', '静海'), ('103', '3', '0', '南开'), ('104', '3', '0', '宁河'), ('105', '3', '0', '宝坻'), ('106', '4', '0', '重庆市'), ('107', '4', '0', '万州'), ('108', '4', '0', '江北'), ('109', '4', '0', '渝中'), ('110', '4', '0', '巴南'), ('111', '4', '0', '沙坪坝'), ('112', '4', '0', '万盛区'), ('113', '4', '0', '南岸'), ('114', '4', '0', '北碚区'), ('115', '4', '0', '渝北'), ('116', '4', '0', '九龙坡'), ('117', '4', '0', '大渡口'), ('118', '4', '0', '双桥'), ('119', '4', '0', '永川'), ('120', '4', '0', '合川'), ('121', '4', '0', '江津'), ('122', '4', '0', '南川'), ('123', '4', '0', '綦江'), ('124', '4', '0', '长寿'), ('125', '4', '0', '潼南'), ('126', '4', '0', '荣昌'), ('127', '4', '0', '璧山'), ('128', '4', '0', '大足'), ('129', '4', '0', '铜梁'), ('130', '4', '0', '梁平'), ('131', '4', '0', '城口'), ('132', '4', '0', '垫江'), ('133', '4', '0', '武隆'), ('134', '4', '0', '丰都'), ('135', '4', '0', '奉节'), ('136', '4', '0', '开县'), ('137', '4', '0', '云阳'), ('138', '4', '0', '忠县'), ('139', '4', '0', '巫溪'), ('140', '4', '0', '巫山'), ('141', '4', '0', '黔江'), ('142', '4', '0', '石柱土'), ('143', '4', '0', '酉阳'), ('144', '4', '0', '秀山'), ('145', '4', '0', '彭水'), ('146', '4', '0', '黔江开发区'), ('147', '4', '0', '涪陵'), ('148', '5', '0', '哈尔滨'), ('149', '5', '0', '齐齐哈尔'), ('150', '5', '0', '鸡西'), ('151', '5', '0', '鹤岗'), ('152', '5', '0', '双鸭山'), ('153', '5', '0', '大庆'), ('154', '5', '0', '伊春'), ('155', '5', '0', '佳木斯'), ('156', '5', '0', '七台河'), ('157', '5', '0', '牡丹江'), ('158', '5', '0', '黑河'), ('159', '5', '0', '绥化'), ('160', '5', '0', '松花江'), ('161', '5', '0', '嫩江'), ('162', '5', '0', '合江'), ('163', '5', '0', '大兴安岭'), ('164', '6', '0', '沈阳'), ('165', '6', '0', '大连'), ('166', '6', '0', '鞍山'), ('167', '6', '0', '抚顺'), ('168', '6', '0', '本溪'), ('169', '6', '0', '丹东'), ('170', '6', '0', '锦州'), ('171', '6', '0', '营口'), ('172', '6', '0', '阜新'), ('173', '6', '0', '辽阳'), ('174', '6', '0', '盘锦'), ('175', '6', '0', '铁岭'), ('176', '6', '0', '朝阳'), ('177', '6', '0', '葫芦岛'), ('178', '7', '0', '长春'), ('179', '7', '0', '吉林'), ('180', '7', '0', '四平'), ('181', '7', '0', '辽源'), ('182', '7', '0', '通化'), ('183', '7', '0', '白山'), ('184', '7', '0', '松原'), ('185', '7', '0', '白城'), ('186', '7', '0', '延边'), ('187', '7', '0', '永吉'), ('188', '7', '0', '德惠'), ('189', '8', '0', '石家庄'), ('190', '8', '0', '唐山'), ('191', '8', '0', '秦皇岛'), ('192', '8', '0', '邯郸'), ('193', '8', '0', '邢台'), ('194', '8', '0', '保定'), ('195', '8', '0', '张家口'), ('196', '8', '0', '承德'), ('197', '8', '0', '沧州'), ('198', '8', '0', '廊坊'), ('199', '8', '0', '衡水'), ('200', '9', '0', '呼和浩特'), ('201', '9', '0', '包头'), ('202', '9', '0', '乌海'), ('203', '9', '0', '赤峰'), ('204', '9', '0', '通辽'), ('205', '9', '0', '鄂尔多斯'), ('206', '9', '0', '呼伦贝尔盟'), ('207', '9', '0', '兴安盟'), ('208', '9', '0', '哲里木盟'), ('209', '9', '0', '昭乌达盟'), ('210', '9', '0', '锡林郭勒盟'), ('211', '9', '0', '乌兰察布盟'), ('212', '9', '0', '伊克昭盟'), ('213', '9', '0', '巴彦淖尔盟'), ('214', '9', '0', '阿拉善盟'), ('215', '10', '0', '西安'), ('216', '10', '0', '铜川'), ('217', '10', '0', '宝鸡'), ('218', '10', '0', '咸阳'), ('219', '10', '0', '渭南'), ('220', '10', '0', '延安'), ('221', '10', '0', '汉中'), ('222', '10', '0', '榆林'), ('223', '10', '0', '安康'), ('224', '10', '0', '商洛'), ('225', '11', '0', '太原'), ('226', '11', '0', '大同'), ('227', '11', '0', '阳泉'), ('228', '11', '0', '长治'), ('229', '11', '0', '晋城'), ('230', '11', '0', '朔州'), ('231', '11', '0', '晋中'), ('232', '11', '0', '运城'), ('233', '11', '0', '忻州'), ('234', '11', '0', '临汾'), ('235', '11', '0', '雁北'), ('236', '11', '0', '忻县'), ('237', '11', '0', '吕梁'), ('238', '11', '0', '晋东南'), ('239', '12', '0', '兰州'), ('240', '12', '0', '嘉峪关'), ('241', '12', '0', '金昌'), ('242', '12', '0', '白银'), ('243', '12', '0', '天水'), ('244', '12', '0', '武威'), ('245', '12', '0', '酒泉'), ('246', '12', '0', '张掖'), ('247', '12', '0', '定西'), ('248', '12', '0', '陇南'), ('249', '12', '0', '平凉'), ('250', '12', '0', '庆阳'), ('251', '12', '0', '临夏'), ('252', '12', '0', '甘南'), ('253', '13', '0', '银川'), ('254', '13', '0', '石嘴山'), ('255', '13', '0', '吴忠'), ('256', '13', '0', '固原'), ('257', '13', '0', '银南'), ('258', '14', '0', '乌鲁木齐'), ('259', '14', '0', '克拉玛依'), ('260', '14', '0', '石河子'), ('261', '14', '0', '吐鲁番'), ('262', '14', '0', '哈密'), ('263', '14', '0', '昌吉'), ('264', '14', '0', '伊犁'), ('265', '14', '0', '塔城'), ('266', '14', '0', '阿勒泰'), ('267', '14', '0', '博尔塔拉'), ('268', '14', '0', '巴音郭楞'), ('269', '14', '0', '阿克苏'), ('270', '14', '0', '克孜勒苏'), ('271', '14', '0', '喀什'), ('272', '14', '0', '和田'), ('273', '15', '0', '拉萨'), ('274', '15', '0', '昌都'), ('275', '15', '0', '山南'), ('276', '15', '0', '日喀则'), ('277', '15', '0', '那曲'), ('278', '15', '0', '阿里'), ('279', '15', '0', '林芝'), ('280', '15', '0', '江孜'), ('281', '16', '0', '西宁'), ('282', '16', '0', '海东'), ('283', '16', '0', '海北'), ('284', '16', '0', '黄南'), ('285', '16', '0', '海南'), ('286', '16', '0', '果洛'), ('287', '16', '0', '玉树'), ('288', '16', '0', '海西'), ('289', '17', '0', '成都'), ('290', '17', '0', '自贡'), ('291', '17', '0', '攀枝花'), ('292', '17', '0', '泸州'), ('293', '17', '0', '德阳'), ('294', '17', '0', '绵阳'), ('295', '17', '0', '广元'), ('296', '17', '0', '遂宁'), ('297', '17', '0', '内江'), ('298', '17', '0', '乐山'), ('299', '17', '0', '万县'), ('300', '17', '0', '南充'), ('301', '17', '0', '眉山'), ('302', '17', '0', '宜宾'), ('303', '17', '0', '广安'), ('304', '17', '0', '达州'), ('305', '17', '0', '雅安'), ('306', '17', '0', '巴中'), ('307', '17', '0', '资阳'), ('308', '17', '0', '永川'), ('309', '17', '0', '涪陵'), ('310', '17', '0', '内江'), ('311', '17', '0', '温江'), ('312', '17', '0', '绵阳'), ('313', '17', '0', '达县'), ('314', '17', '0', '黔江'), ('315', '17', '0', '凉山'), ('316', '18', '0', '昆明'), ('317', '18', '0', '东川'), ('318', '18', '0', '曲靖'), ('319', '18', '0', '玉溪'), ('320', '18', '0', '保山'), ('321', '18', '0', '昭通'), ('322', '18', '0', '楚雄'), ('323', '18', '0', '红河'), ('324', '18', '0', '文山'), ('325', '18', '0', '思茅'), ('326', '18', '0', '西双版纳'), ('327', '18', '0', '大理'), ('328', '18', '0', '德宏'), ('329', '18', '0', '丽江'), ('330', '18', '0', '怒江'), ('331', '18', '0', '迪庆'), ('332', '18', '0', '临沧'), ('333', '19', '0', '贵阳'), ('334', '19', '0', '六盘水'), ('335', '19', '0', '遵义'), ('336', '19', '0', '安顺'), ('337', '19', '0', '铜仁'), ('338', '19', '0', '黔西南'), ('339', '19', '0', '毕节'), ('340', '19', '0', '黔东南'), ('341', '19', '0', '黔南'), ('342', '20', '0', '长沙'), ('343', '20', '0', '株洲'), ('344', '20', '0', '湘潭'), ('345', '20', '0', '衡阳'), ('346', '20', '0', '邵阳'), ('347', '20', '0', '岳阳'), ('348', '20', '0', '常德'), ('349', '20', '0', '张家界'), ('350', '20', '0', '益阳'), ('351', '20', '0', '郴州'), ('352', '20', '0', '永州'), ('353', '20', '0', '怀化'), ('354', '20', '0', '娄底'), ('355', '20', '0', '零陵'), ('356', '20', '0', '怀北'), ('357', '20', '0', '湘西'), ('358', '21', '0', '武汉'), ('359', '21', '0', '黄石'), ('360', '21', '0', '十堰'), ('361', '21', '0', '沙市'), ('362', '21', '0', '宜昌'), ('363', '21', '0', '襄樊'), ('364', '21', '0', '鄂州'), ('365', '21', '0', '荆门'), ('366', '21', '0', '孝感'), ('367', '21', '0', '荆州'), ('368', '21', '0', '黄冈'), ('369', '21', '0', '咸宁'), ('370', '21', '0', '随州'), ('371', '21', '0', '襄阳'), ('372', '21', '0', '郧阳'), ('373', '22', '0', '郑州'), ('374', '22', '0', '开封'), ('375', '22', '0', '洛阳'), ('376', '22', '0', '平顶山'), ('377', '22', '0', '安阳'), ('378', '22', '0', '鹤壁'), ('379', '22', '0', '新乡'), ('380', '22', '0', '焦作'), ('381', '22', '0', '濮阳'), ('382', '22', '0', '许昌'), ('383', '22', '0', '漯河'), ('384', '22', '0', '三门峡'), ('385', '22', '0', '南阳'), ('386', '22', '0', '商丘'), ('387', '22', '0', '信阳'), ('388', '22', '0', '周口'), ('389', '22', '0', '驻马店'), ('390', '23', '0', '济南'), ('391', '23', '0', '青岛'), ('392', '23', '0', '淄博'), ('393', '23', '0', '枣庄'), ('394', '23', '0', '东营'), ('395', '23', '0', '烟台'), ('396', '23', '0', '潍坊'), ('397', '23', '0', '济宁'), ('398', '23', '0', '泰安'), ('399', '23', '0', '威海'), ('400', '23', '0', '日照'), ('401', '23', '0', '莱芜'), ('402', '23', '0', '临沂'), ('403', '23', '0', '德州'), ('404', '23', '0', '聊城'), ('405', '23', '0', '滨州'), ('406', '23', '0', '菏泽'), ('407', '24', '0', '合肥'), ('408', '24', '0', '芜湖'), ('409', '24', '0', '蚌埠'), ('410', '24', '0', '淮南'), ('411', '24', '0', '马鞍山'), ('412', '24', '0', '淮北'), ('413', '24', '0', '铜陵'), ('414', '24', '0', '安庆'), ('415', '24', '0', '黄山'), ('416', '24', '0', '滁州'), ('417', '24', '0', '阜阳'), ('418', '24', '0', '宿州'), ('419', '24', '0', '巢湖'), ('420', '24', '0', '六安'), ('421', '24', '0', '亳州'), ('422', '24', '0', '池州'), ('423', '24', '0', '宣城'), ('424', '24', '0', '徽州'), ('425', '25', '0', '南京'), ('426', '25', '0', '无锡'), ('427', '25', '0', '徐州'), ('428', '25', '0', '常州'), ('429', '25', '0', '苏州'), ('430', '25', '0', '南通'), ('431', '25', '0', '连云港'), ('432', '25', '0', '淮安'), ('433', '25', '0', '盐城'), ('434', '25', '0', '扬州'), ('435', '25', '0', '镇江'), ('436', '25', '0', '泰州'), ('437', '25', '0', '宿迁'), ('438', '25', '0', '淮阴'), ('439', '26', '0', '杭州'), ('440', '26', '0', '宁波'), ('441', '26', '0', '温州'), ('442', '26', '0', '嘉兴'), ('443', '26', '0', '湖州'), ('444', '26', '0', '绍兴'), ('445', '26', '0', '金华'), ('446', '26', '0', '衢州'), ('447', '26', '0', '舟山'), ('448', '26', '0', '台州'), ('449', '26', '0', '丽水'), ('450', '27', '0', '台湾'), ('451', '28', '0', '香港'), ('452', '29', '0', '澳门'), ('453', '30', '0', '广州'), ('454', '30', '0', '韶关'), ('455', '30', '0', '深圳'), ('456', '30', '0', '珠海'), ('457', '30', '0', '汕头'), ('458', '30', '0', '佛山'), ('459', '30', '0', '江门'), ('460', '30', '0', '湛江'), ('461', '30', '0', '茂名'), ('462', '30', '0', '海口'), ('463', '30', '0', '肇庆'), ('464', '30', '0', '惠州'), ('465', '30', '0', '梅州'), ('466', '30', '0', '汕尾'), ('467', '30', '0', '河源'), ('468', '30', '0', '阳江'), ('469', '30', '0', '清远'), ('470', '30', '0', '东莞'), ('471', '30', '0', '中山'), ('472', '30', '0', '梅县'), ('473', '30', '0', '惠阳'), ('474', '30', '0', '潮州'), ('475', '30', '0', '揭阳'), ('476', '30', '0', '云浮'), ('477', '31', '0', '南宁'), ('478', '31', '0', '柳州'), ('479', '31', '0', '桂林'), ('480', '31', '0', '梧州'), ('481', '31', '0', '北海'), ('482', '31', '0', '防城港'), ('483', '31', '0', '钦州'), ('484', '31', '0', '贵港'), ('485', '31', '0', '玉林'), ('486', '31', '0', '贺州'), ('487', '31', '0', '百色'), ('488', '31', '0', '河池'), ('489', '32', '0', '南昌'), ('490', '32', '0', '景德镇'), ('491', '32', '0', '萍乡'), ('492', '32', '0', '九江'), ('493', '32', '0', '新余'), ('494', '32', '0', '鹰潭'), ('495', '32', '0', '抚州'), ('496', '32', '0', '上饶'), ('497', '32', '0', '赣州'), ('498', '32', '0', '宜春'), ('499', '32', '0', '吉安'), ('500', '33', '0', '福州'), ('501', '33', '0', '厦门'), ('502', '33', '0', '莆田'), ('503', '33', '0', '三明'), ('504', '33', '0', '泉州'), ('505', '33', '0', '漳州'), ('506', '33', '0', '南平'), ('507', '33', '0', '龙岩'), ('508', '33', '0', '宁德'), ('509', '33', '0', '晋江'), ('510', '33', '0', '龙溪'), ('511', '34', '0', '海口'), ('512', '34', '0', '三亚'), ('513', '35', '0', '其他'), ('514', '36', '0', '美国'), ('515', '37', '0', '欧洲'), ('516', '38', '0', '日本'), ('517', '39', '0', '韩国'), ('518', '40', '0', '新加坡'), ('519', '41', '0', '加拿大'), ('520', '42', '0', '亚　洲'), ('521', '43', '0', '非　洲'), ('522', '44', '0', '澳　洲'), ('523', '45', '0', '南美洲'), ('524', '46', '0', '东南亚');
COMMIT;

-- ----------------------------
--  Table structure for `ks_config`
-- ----------------------------
DROP TABLE IF EXISTS `ks_config`;
CREATE TABLE `ks_config` (
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `content` text NOT NULL COMMENT '配置内容',
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='配置信息表';

-- ----------------------------
--  Records of `ks_config`
-- ----------------------------
BEGIN;
INSERT INTO `ks_config` VALUES ('setting', '{\"base_url\":\"\",\"index_page\":\"index.php\",\"site_state\":true,\"sitename\":\"\\u6c34\\u6d52\",\"res_url\":\"\\/res\",\"host_url\":\"http:\\/\\/127.0.0.3\\/api\\/\",\"area_id\":\"\",\"area_name\":\"\\u6d4b\\u8bd5\",\"socket_port\":8523,\"timezone\":\"Asia\\/Harbin\",\"languages\":{\"admin\":\"zh_CN\",\"application\":\"zh_CN\"},\"apc\":{\"state\":\"true\"},\"error_log\":\"true\",\"open_magic_quotes_gpc\":true,\"code_log\":\"*\",\"white_list\":\"\",\"forbidden_nickname\":\"\\u6447\\u4e00\\u6447,\\u6709\\u60ca\\u559c\\u54e6!|\\u7ba1\\u7406\\u5458|\\u5ba2\\u670d\\u4e13\\u5458|\\u5ba2\\u670d\\u4eba\\u5458|admin|\\u5ba2\\u670d|\\u7cfb\\u7edf\",\"forbidden_deviceid\":\"fsdasdf|fsd\",\"url_search\":[],\"url_replace\":[\"\"],\"root_controller\":\"\",\"root_action\":\"\",\"default_controller\":\"index\",\"default_action\":\"index\",\"allow_version\":null,\"deny_version\":null,\"version\":\"2.0.01\",\"url_rewrite\":true,\"currency_list\":{\"1\":{\"id\":1,\"name\":\"\\u6e2f\\u5e01\",\"rate\":\"0.7920\"},\"2\":{\"id\":\"revenue\",\"name\":\"\",\"rate\":\"\"},\"3\":{\"id\":2,\"name\":\"\\u4eba\\u6c11\\u5e01\",\"rate\":\"1.0000\"},\"4\":{\"id\":3,\"name\":\"\\u7f8e\\u5143\",\"rate\":\"6.1507\"},\"5\":{\"id\":4,\"name\":\"\\u8d8a\\u5357\\u76fe\",\"rate\":\"0.0003\"}},\"site_state_text\":\"\",\"ip_ban\":\"\",\"ip_ban_text\":\"\",\"filter_words\":\"\",\"email\":{\"smtp_server\":\"smtp.ym.163.com\",\"port\":\"25\",\"username\":\"noreply@songyouhui.com\",\"password\":\"songyouhui2011\"},\"email_confirm\":\"false\",\"note\":{\"register_title\":\"{username}\\uff0c\\u6b22\\u8fce\\u60a8\\u52a0\\u5165\\u8bb0\\u8d26\\u5bb6\\uff01\",\"register_content\":\"{username}\\uff0c\\u6b22\\u8fce\\u60a8\\u52a0\\u5165\\u8bb0\\u8d26\\u5bb6\\uff01\"}}'), ('sql', 'select * from sg_user u left join sg_user_extension ue on u.id=ue.user_id left join sg_user_resource ur on u.id=ur.user_id left join sg_user_count uc on u.id=uc.user_id where u.id=\'3\'; #筛选指定会员ID的玩家信息###update sg_user_resource set scroll=0,accelerator=0,stopattack=0,transfer=0; #将所有玩家的卷轴、兵符、免战牌、传输令都置为0'), ('update', '<p><strong>请点击增加日志来填写日志</strong></p><p></p>'), ('tips', ''), ('feed', '{\"share\":{\"name\":\"\\u5206\\u4eab\\u6e38\\u620f\",\"desc\":\"\\u53d1\\u73b0\\u4e00\\u4e2a\\u597d\\u73a9\\u7684\\u6e38\\u620f\",\"title\":\"\\u4f60\\u8fd9\\u4e00\\u751f\\u4e0d\\u53ef\\u9519\\u8fc7\\u7684\\u597d\\u6e38\\u620f\",\"summary\":\"\\u6709\\u4ec0\\u4e48\\u6e38\\u620f\\u662f\\u4f60\\u4e00\\u751f\\u4e0d\\u53ef\\u9519\\u8bef\\u7684\\u597d\\u6e38\\u620f\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/1.png\"},\"achievement\":{\"name\":\"\\u83b7\\u5f97\\u6210\\u5c31\",\"desc\":\"\\u4f60\\u4e5f\\u60f3\\u83b7\\u5f97\\u8be5\\u6210\\u5c31\\u5417\\uff1f\\u5feb\\u5feb\\u884c\\u52a8\\u5427\\uff01\",\"title\":\"\\u6211\\u53d6\\u5f97\\u4e86\\u65b0\\u7684\\u6210\\u5c31{name},\\u767e\\u5206\\u4e4b{percent}\\u7684\\u673a\\u7387,\\u7b2c{index}\\u4f4d\\u83b7\\u5f97,\\u6709\\u6ca1\\u6709\\u5f88\\u5389\\u5bb3\",\"summary\":\"\\u53ea\\u8981{intro}\\uff0c\\u5373\\u53ef\\u83b7\\u5f97{award}\",\"button\":\"\\u9886\\u53d6\\u5956\\u52b1\",\"pics\":\"{resurl}{image}\"},\"pk_entrance\":{\"name\":\"\\u53d1\\u8d77PK\\u6311\\u6218\",\"desc\":\"\\u4f60\\u8d76\\u6765\\u6311\\u6218\\u5417\\uff1f\",\"title\":\"\\u6211\\u5728\\u4e09\\u56fd\\u6218\\u8bb0{name}\\u4e2d\\u5411@{username} \\u53d1\\u8d77\\u4e86PK\\u6311\\u6218\",\"summary\":\"\\u6211\\u6b63\\u5728\\u4e09\\u56fd\\u6218\\u8bb0{name}\\u5411@{username} \\u53d1\\u8d77\\u4e86PK\\u6311\\u6218,\\u6709\\u8c01\\u6765\\u5e2e\\u5e2e\\u6211\\u62a2\\u593a\\u4ed6\\u7684\\u8d44\\u6e90\\uff01\",\"button\":\"\\u5e2e\\u52a9TA\",\"pics\":\"{resurl}\\/images\\/feed\\/3.png\"},\"pk_success\":{\"name\":\"PK\\u6210\\u529f\",\"desc\":\"\\u6709\\u6728\\u6709\\u5f88\\u5389\\u5bb3\\uff01\\u6211\\u5f97\\u8bb0\\u5f55\\u8fd9\\u5386\\u53f2\\u6027\\u7684\\u4e00\\u523b:{createtime}\",\"title\":\"\\u6211\\u5728\\u4e09\\u56fd\\u6218\\u8bb0{name}\\u4e2d\\u5411@{username} \\u53d1\\u8d77\\u4e86PK\\u6311\\u6218\\u7ec8\\u4e8e\\u6210\\u529f\\u4e86\",\"summary\":\"\\u6211\\u5728\\u4e09\\u56fd\\u6218\\u8bb0{name}\\u4e2d\\u5411@{username} \\u53d1\\u8d77\\u4e86PK\\u6311\\u6218\\u7ec8\\u4e8e\\u6210\\u529f\\u4e86\\uff01\\u7279\\u6709\\u6210\\u5c31\\u611f\\uff01\\u6709\\u6728\\u6709\\uff01\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/4.png\"},\"arena_entrance\":{\"name\":\"\\u53d1\\u8d77\\u64c2\\u53f0\\u6311\\u6218\",\"desc\":\"\\u5927\\u5bb6\\u5feb\\u6765\\u795d\\u798f\\u6211\\u80fd\\u6311\\u64c2\\u6210\\u529f\\u5427\\uff01\",\"title\":\"\\u6211\\u5728\\u4e09\\u56fd\\u6218\\u8bb0\\u4e2d\\u7684\\u6311\\u64c2\\u8d5b\\u4e2d\\u5411\\u64c2\\u4e3b@{username}\\u53d1\\u8d77\\u4e86\\u6311\\u6218\",\"summary\":\"\\u76ee\\u524d\\u8be5\\u64c2\\u53f0\\u5df2\\u7ecf\\u6709{challengers}\\u4eba\\u6311\\u6218\\uff0c\\u800c\\u6210\\u529f\\u6311\\u64c2\\u7684\\u4eba\\u6570\\u4ec5\\u4ec5{wins}\\u4eba,\\u603b\\u5956\\u6c60\\u5df2\\u7ecf\\u7d2f\\u8ba1\\u8fbe\\u5230{jackpots}\\uff0c\\u53ea\\u8981\\u4f60\\u6562\\u6765\\uff0c\\u4f60\\u4e5f\\u5c31\\u6709\\u673a\\u4f1a\\uff01\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/5.png\"},\"arena_success\":{\"name\":\"\\u6311\\u64c2\\u6210\\u529f\",\"desc\":\"\\u8fd9\\u662f\\u5386\\u53f2\\u6027\\u7684\\u4e00\\u523b\",\"title\":\"\\u6211\\u521a\\u624d\\u5728\\u4e09\\u56fd\\u6218\\u8bb0\\u64c2\\u53f0\\u8d5b\\u5411\\u64c2\\u4e3b@{username}\\u53d1\\u8d77\\u7684\\u6311\\u6218\\u6210\\u529f\\u4e86\\uff01\",\"summary\":\"\\u5c45\\u7136\\u88ab\\u6211\\u6311\\u64c2\\u6210\\u529f\\u4e86\\u3002\\u83b7\\u5f97\\u4e86\\u5956\\u6c60\\u7684\\u6240\\u6709\\u5956\\u91d1\\uff0c\\u7d2f\\u8ba1\\u8fbe\\u5230{jackpots}\\uff0c\\u771f\\u662f\\u5927\\u5927\\u7684\\u6536\\u83b7\\u5440\\uff01\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/6.png\"},\"castle_success\":{\"name\":\"\\u4e3b\\u57ce\\u6536\\u53d6\\u6210\\u529f\",\"desc\":\"\\u4eca\\u5929\\u53c8\\u6709\\u6536\\u83b7\\u4e86\\uff01\",\"title\":\"\\u4e3b\\u57ce\\u514d\\u8d39\\u6536\\u53d6\\u8d44\\u6e90\\u5566\",\"summary\":\"\\u6210\\u529f\\u83b7\\u5f97\\u8d44\\u6e90 \\u5143\\u5b9d:{coin} \\u6728\\u6750:{wood} \\u77f3\\u6750:{stone} \\u9152:{wine} \\u8089:{meat}\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/7.png\"},\"castle_pillage\":{\"name\":\"\\u4e3b\\u57ce\\u62a2\\u593a\\u6210\\u529f\",\"desc\":\"\\u62a2\\u8d44\\u6e90\\u5566\\uff01\",\"title\":\"\\u6211\\u5230{nickname}\\u7684\\u4e3b\\u57ce\\u63a0\\u593a\\u4e86\\u90e8\\u5206\\u8d44\\u6e90\",\"summary\":\"\\u6210\\u529f\\u83b7\\u5f97\\u8d44\\u6e90 \\u5143\\u5b9d:{coin} \\u6728\\u6750:{wood} \\u77f3\\u6750:{stone} \\u9152:{wine} \\u8089:{meat}\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/8.png\"},\"update\":{\"name\":\"\\u7b49\\u7ea7\\u63d0\\u5347\",\"desc\":\"\\u5347\\u7ea7\\u5566\\uff01\\uff01\\uff01\",\"title\":\"\\u771f\\u662f\\u592a\\u4e0d\\u5bb9\\u6613\\u4e86\\uff0c\\u7ec8\\u4e8e\\u5347\\u5230{lv}\\u7ea7\\u4e86\",\"summary\":\"\\u6211\\u5728\\u4e09\\u56fd\\u6218\\u8bb0\\u4e2d\\u7684\\u7b49\\u7ea7\\u8fde\\u5347{upgrade}\\u7ea7\\uff0c\\u76ee\\u524d\\u5df2\\u7ecf\\u8fbe\\u5230{lv}\\u7ea7\\u4e86\\uff0c\\u989d\\u5916\\u8fd8\\u83b7\\u5f97\\u4e86\\u5956\\u52b1\\u5305{$award}\",\"button\":\"\\u9886\\u53d6\\u5956\\u52b1\",\"pics\":\"{resurl}\\/images\\/feed\\/9.png\"},\"task\":{\"name\":\"\\u65b0\\u624b\\u4efb\\u52a1\",\"desc\":\"\",\"title\":\"\\u6211\\u6b63\\u5728\\u8fdb\\u884c\\u7279\\u6b8a\\u4efb\\u52a1\\uff0c\\u9700\\u8981\\u5927\\u4fa0\\u5e2e\\u52a9\\uff0c\\u54ea\\u4f4d\\u5927\\u4fa0\\u80fd\\u9f0e\\u529b\\u76f8\\u52a9\\uff01\",\"summary\":\"\\u6211\\u6b63\\u5728\\u5b8c\\u6210\\u4e09\\u56fd\\u6218\\u8bb0\\u7684\\u4efb\\u52a1\\uff0c\\u5b8c\\u6210\\u540e\\u53ef\\u83b7\\u5f97\\u795e\\u79d8\\u5927\\u793c\\u5305\\uff0c\\u5feb\\u6765\\u5e2e\\u5e2e\\u6211\",\"button\":\"\\u5e2e\\u52a9TA\",\"pics\":\"{resurl}\\/images\\/feed\\/10.png\"},\"battle_champion\":{\"name\":\"\\u51fa\\u5f81\\u95ef\\u5173\\u6210\\u529f\\u5e76\\u6392\\u884c\\u7b2c\\u4e00\",\"desc\":\"\\u52c7\\u593a\\u7b2c\\u4e00\",\"title\":\"\\u6211\\u83b7\\u5f97\\u7b2c\\u4e00\\u540d\\u4e86\",\"summary\":\"\\u6210\\u529f\\u95ef\\u5173{name}\\uff0c\\u5e76\\u52c7\\u593a\\u7b2c\\u4e00\\uff0c\\u6211\\u7684\\u95ef\\u5173\\u5206\\u6570\\u662f\\uff1a {score}\\uff0c\\u76ee\\u524d\\u5df2\\u6709{challengers}\\u5c1d\\u8bd5\\u95ef\\u5173\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/11.png\"},\"battle_soldier\":{\"name\":\"\\u51fa\\u5f81\\u95ef\\u5173\\u6210\\u529f\\u5e76\\u89e3\\u9501\\u5173\\u5361\",\"desc\":\"\\u6210\\u529f\\u89e3\\u9501\\u5175\\u79cd\",\"title\":\"\\u6211\\u7684\\u80cc\\u5305\\u4e2d\\u65b0\\u589e\\u65b0\\u7684\\u5175\\u79cd{soldiers}\",\"summary\":\"\\u6210\\u529f\\u95ef\\u5173{name}\\uff0c\\u5e76\\u89e3\\u9501\\u5175\\u79cd\\uff0c\\u6211\\u7684\\u95ef\\u5173\\u5206\\u6570\\u662f\\uff1a {score}\\uff0c\\u76ee\\u524d\\u5df2\\u6709{challengers}\\u5c1d\\u8bd5\\u95ef\\u5173\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/12.png\"},\"battle_chapter\":{\"name\":\"\\u51fa\\u5f81\\u95ef\\u5173\\u6210\\u529f\\u5e76\\u89e3\\u9501\\u5173\\u5361\",\"desc\":\"\\u6210\\u529f\\u89e3\\u9501\\u5173\\u5361\",\"title\":\"\\u6210\\u529f\\u89e3\\u9501\\u65b0\\u7684\\u5173\\u5361{nextname}\",\"summary\":\"\\u6210\\u529f\\u95ef\\u5173{name}\\uff0c\\u5e76\\u89e3\\u9501\\u5173\\u5361{nextname}\\uff0c\\u6211\\u7684\\u95ef\\u5173\\u5206\\u6570\\u662f\\uff1a {score}\\uff0c\\u76ee\\u524d\\u5df2\\u6709{challengers}\\u5c1d\\u8bd5\\u95ef\\u5173\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/13.png\"},\"battle_success\":{\"name\":\"\\u51fa\\u5f81\\u95ef\\u5173\\u6210\\u529f\",\"desc\":\"\\u6210\\u529f\\u95ef\\u5173\",\"title\":\"\\u6210\\u529f\\u5173\\u5361{name}\",\"summary\":\"\\u6210\\u529f\\u95ef\\u5173{name}\\uff0c\\u6211\\u7684\\u95ef\\u5173\\u5206\\u6570\\u662f\\uff1a {score}\\uff0c\\u76ee\\u524d\\u5df2\\u6709{challengers}\\u4eba\\u5c1d\\u8bd5\\u95ef\\u5173\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/14.png\"},\"battle_share\":{\"name\":\"\\u51fa\\u5f81\\u5206\\u4eab\",\"desc\":\"\\u95ef\\u5173\\u5206\\u4eab\",\"title\":\"\\u6311\\u6218{name}\",\"summary\":\"\\u6311\\u6218{name}\\uff0c\\u603b\\u95ef\\u5173\\u4eba\\u6570{challengers}\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}\\/images\\/feed\\/15.png\"},\"luckydraw\":{\"name\":\"\\u767b\\u5f55\\u62bd\\u5956\",\"desc\":\"\\u6211\\u4e2d\\u5956\\u4e86\\uff0c\\u4f60\\u4e5f\\u6709\\u673a\\u4f1a\\u54e6\",\"title\":\"\\u6211\\u4e2d\\u5956\\u4e86\\uff01\\uff01\\uff01\\uff01\\uff01\\uff01\\uff01\\uff01\\uff01\\uff01\",\"summary\":\"\\u6211\\u62bd\\u4e2d\\u4e86{name}\\uff0c\\u76ee\\u524d\\u6211\\u5df2\\u7ecf\\u603b\\u4e86\\u5171\\u4ef7\\u503c\\u8d85\\u8fc7{total}\\uff0c\\u6392\\u540d\\u7b2c{index}\\u540d\",\"button\":\"\\u8fdb\\u5165\\u5e94\\u7528\",\"pics\":\"{resurl}{image}\"},\"online\":{\"name\":\"\\u5728\\u7ebf\\u5956\\u52b1\",\"desc\":\"\\u9886\\u5728\\u7ebf\\u5956\\u52b1\\u4e86\",\"title\":\"\\u9886\\u5728\\u7ebf\\u5956\\u52b1\\u4e86\",\"summary\":\"\\u5728\\u7ebf10\\u5206\\u949f\\u5c31\\u6709\\u4e30\\u5bcc\\u5956\\u52b1\\uff0c\\u5feb\\u6765\\u9886\\u53d6\\u5440\",\"button\":\"\\u9886\\u53d6\\u5956\\u52b1\",\"pics\":\"{resurl}\\/images\\/feed\\/default.jpg\"},\"reactive\":{\"name\":\"\\u53ec\\u5524\\u597d\\u53cb\",\"send\":{\"image\":\"{resurl}\\/images\\/feed\\/default.jpg\",\"props\":\"1*6\"},\"receive\":{\"image\":\"{resurl}\\/images\\/feed\\/default.jpg\",\"props\":\"1*3\"},\"summary\":\"fsdsdf\"}}');
COMMIT;

-- ----------------------------
--  Table structure for `ks_connect`
-- ----------------------------
DROP TABLE IF EXISTS `ks_connect`;
CREATE TABLE `ks_connect` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '编号',
  `uid` varchar(32) NOT NULL DEFAULT '' COMMENT '应用的用户ID',
  `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '站内的用户ID',
  `default_user_id` int(10) NOT NULL DEFAULT '0' COMMENT '默认生成的账户ID',
  `app` varchar(10) NOT NULL DEFAULT 'renren' COMMENT '应用ID',
  `createtime` int(10) NOT NULL DEFAULT '0' COMMENT '绑定时间',
  `state` int(1) NOT NULL DEFAULT '0' COMMENT '绑定状态 0未连接 1已连接',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `default_user_id` (`default_user_id`),
  KEY `app` (`app`)
) ENGINE=MyISAM AUTO_INCREMENT=17505 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `ks_connect`
-- ----------------------------
BEGIN;
INSERT INTO `ks_connect` VALUES ('17504', '1905148067', '5', '0', 'weibo', '1367288295', '1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_crontab`
-- ----------------------------
DROP TABLE IF EXISTS `ks_crontab`;
CREATE TABLE `ks_crontab` (
  `id` varchar(36) NOT NULL COMMENT '主键',
  `type` varchar(10) NOT NULL DEFAULT '' COMMENT '事件类型',
  `title` varchar(100) NOT NULL COMMENT '事件标题',
  `cron` varchar(250) NOT NULL DEFAULT '' COMMENT 'cron参数',
  `content` text NOT NULL COMMENT '事件内容',
  `frequence` varchar(30) NOT NULL DEFAULT 'once' COMMENT '频率 once 和 repeat',
  `executes` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已经执行的次数',
  `maximums` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大执行次数 0为不限',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '开始时间',
  `expiretime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
  `executetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行时间',
  `lastexecutetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后执行时间',
  `weigh` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序 权重 任务执行先后顺序',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 -1已过期 0未执行 1已执行 2已完成',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='通用链接表';

-- ----------------------------
--  Records of `ks_crontab`
-- ----------------------------
BEGIN;
INSERT INTO `ks_crontab` VALUES ('41', 'module', '留存率统计', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\",\"module\":\"statistics\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"0\",\"hour\":\"0\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '977', '0', '1356786872', '1356787269', '0', '1356787269', '1373731201', '41', '1'), ('77', 'notice', '卡', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4eb2\\u7231\\u7684\\u6c34\\u6d52\\u82f1\\u96c4\\u4eec\\uff0c\\u65b0\\u7248\\u66f4\\u65b0\\u540e\\u90e8\\u5206\\u73a9\\u5bb6\\u51fa\\u73b0\\u6bd4\\u8f83\\u5361\\u7684\\u60c5\\u51b5\\uff0c\\u9488\\u5bf9\\u6b64\\u4e8b\\u5b98\\u65b9\\u6b63\\u5728\\u6781\\u529b\\u4f18\\u5316\\uff0c\\u4ee5\\u4fdd\\u969c\\u5e2e\\u4f1a\\u6218\\u7684\\u987a\\u7545\\u8fdb\\u884c\\uff0c\\u8bf7\\u5927\\u5bb6\\u8010\\u5fc3\\u7b49\\u5f85\\uff01\\r\\n\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1363441446', '1363363200', '0', '1363441980', '1363441982', '77', '2'), ('ce306cff-208a-40ee-94fc-251daa3c6c55', 'notice', '5-7服停服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4e3a\\u4e86\\u63d0\\u4f9b\\u66f4\\u7a33\\u5b9a\\u7684\\u7f51\\u7edc\\u73af\\u5883\\uff0c\\u5c06\\u4e8e2013\\/06\\/25  14:10\\u505c\\u670d\\u7ef4\\u62a4\\uff0c\\u9884\\u8ba1\\u65f6\\u957f1\\u4e2a\\u5c0f\\u65f6\\uff0c\\u8bf7\\u5927\\u5bb6\\u4e92\\u76f8\\u8f6c\\u544a\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"*\\/20\",\"hour\":\"*\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '2', '0', '1372137634', '1372137670', '1372140613', '1372138080', '1372140002', '41', '-1'), ('45', 'notice', 'QQ', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u6b22\\u8fce\\u73a9\\u5bb6\\u8fdb\\u9a7b\\u300a\\u6c34\\u6d52\\u82f1\\u96c4\\u300bQQ\\u4ea4\\u6d41\\u7fa4\\uff08\\u7fa4\\u53f7\\uff1a238642834\\uff09\\uff0c\\u5728\\u8fd9\\u91cc\\u4e0d\\u4ec5\\u80fd\\u804a\\u5929\\u704c\\u6c34\\uff0c\\u8fd8\\u80fd\\u7ed3\\u8bc6\\u65b0\\u670b\\u53cb\\uff0c\\u66f4\\u80fd\\u77e5\\u6653\\u66f4\\u591a\\u7684\\u6e38\\u620f\\u8d44\\u8baf\\u3002\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1357196367', '1357142400', '0', '1357196460', '1357196461', '45', '2'), ('48', 'notice', 'tip1', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u5c0a\\u656c\\u7684\\u73a9\\u5bb6\\uff0c\\u9996\\u514510\\u5143\\u5373\\u53ef\\u6210\\u4e3a\\u6211\\u4eec\\u5c0a\\u8d35\\u7684VIP\\uff0c\\u8fd8\\u80fd\\u83b7\\u5f97\\u7279\\u6b8a\\u7684\\u7d2b\\u8272\\u82f1\\u96c4\\uff0c\\u7d2b\\u8272\\u795e\\u5668\\u7b49\\u4e30\\u539a\\u793c\\u54c1\\uff0c\\u8fd8\\u7b49\\u4ec0\\u4e48\\u5462\\uff1f\\u8d76\\u5feb\\u70b9\\u51fb\\u6e38\\u620f\\u4e0a\\u65b9\\u7684\\u9996\\u5145\\u793c\\u5305\\u67e5\\u770b\\u8be6\\u7ec6\\u5185\\u5bb9\\u5427\\u3002\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1357204057', '1357142400', '0', '1357204140', '1357204141', '48', '2'), ('57', 'notice', 'tip1', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u6e29\\u99a8\\u63d0\\u793a\\uff1a\\u6253\\u901a\\u5173\\u5361\\u540e\\u89e3\\u9501\\u82f1\\u96c4\\uff0c\\u89e3\\u9501\\u7684\\u82f1\\u96c4\\u5728\\u805a\\u4e49\\u754c\\u9762\\u4e2d\\u8d2d\\u4e70\\uff0c\\u5373\\u53ef\\u62e5\\u6709\\u3002\\u6700\\u591a\\u53ef\\u6d3e\\u51fa5\\u4e2a\\u82f1\\u96c4\\u5171\\u540c\\u4e0a\\u9635\\u6740\\u654c\\u3002\\u5927\\u5bb6\\u7ee7\\u7eed\\u52aa\\u529b\\u54e6\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1358307705', '1358265600', '0', '1358308260', '1358308261', '57', '2'), ('5d04c9df-e32a-4c69-884f-f23a0d9ab61d', 'notice', '43服开服老服通知', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S43\\u3010\\u9f99\\u4e89\\u864e\\u6597\\u3011\\u4e8e2013\\/06\\/23 10:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"7\",\"hour\":\"\\uff0a\",\"day\":\"*\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371919493', '1371919534', '1371969936', '1371919980', '0', '39', '-1'), ('12c0f15f-f6e4-49e3-ae3a-61023d4a7ff7', 'notice', '43服开服新服开服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S43\\u3010\\u9e6c\\u868c\\u76f8\\u4e89\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"7\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '19', '0', '1371919790', '1371916800', '1372175434', '1371920160', '1372169221', '40', '-1'), ('56', 'notice', 's2开新区', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4eb2\\u7231\\u7684\\u300a\\u6c34\\u6d52\\u82f1\\u96c4\\u300b\\u73a9\\u5bb6\\uff0c\\u5b98\\u65b9\\u5c06\\u5b9a\\u4e8e2012\\/01\\/16 11:00\\u51c6\\u65f6\\u5f00\\u542fS2\\u3010\\u5929\\u7f61\\u5730\\u715e\\u3011\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1358305138', '1358265600', '0', '1358305140', '1358305141', '56', '2'), ('6ab59dc4-ecaf-4492-9a96-9044b26becce', 'notice', '42服开服老服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S42\\u3010\\u9e6c\\u868c\\u76f8\\u4e89\\u3011\\u4e8e2013\\/06\\/20 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"6\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371658106', '1371658147', '1371708550', '1371658620', '0', '37', '-1'), ('44399d9c-5171-4150-af0a-14a9de42aad8', 'notice', '42服开服新服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S42\\u3010\\u9e6c\\u868c\\u76f8\\u4e89\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"6\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371658188', '1371658227', '1371913831', '1371658680', '0', '38', '-1'), ('ad588691-3c11-45b1-8981-69c3167ffe1e', 'notice', '41服开服新服通知', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"   S41\\u3010\\u9e64\\u7acb\\u9e21\\u7fa4\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"6\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371399142', '1371399192', '1371658399', '1371399600', '0', '36', '-1'), ('37a5c2a9-df64-4f24-8270-27cdd7da5cf1', 'notice', '41服开服老服通告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S41\\u3010\\u9e64\\u7acb\\u9e21\\u7fa4\\u3011\\u4e8e2013\\/06\\/17 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"2\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371399048', '1371399085', '1371449489', '1371399420', '0', '35', '-1'), ('98917bde-b3a5-4c1e-b34d-8c77f60c4bcf', 'notice', 's5--s10合服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u5c0a\\u656c\\u7684\\u5404\\u4f4d\\u73a9\\u5bb6\\uff0cs5-s10\\u5c06\\u4e8e2013\\/06\\/14  09\\u70b9\\u81f310\\u70b9\\u8fdb\\u884c\\u6570\\u636e\\u5e93\\u8fde\\u901a\\uff0c\\u5c4a\\u65f6\\u65e0\\u6cd5\\u767b\\u5165\\uff0c\\u8bf7\\u4e92\\u76f8\\u544a\\u77e5\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"4\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371140084', '1371140114', '1371178817', '1371140460', '0', '34', '-1'), ('65', 'notice', '新年1', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u65b0\\u6625\\u4f73\\u8282\\uff0c\\u300a\\u6c34\\u6d52\\u82f1\\u96c4\\u300b\\u56e2\\u961f\\u7ed9\\u5927\\u5bb6\\u62dc\\u5e74\\u4e86\\u3002\\u795d\\u6881\\u5c71\\u7684\\u82f1\\u96c4\\u597d\\u6c49\\u4eec\\u7ecf\\u9a8c\\u591a\\u3001\\u94dc\\u94b1\\u591a\\u3001\\u5143\\u5b9d\\u591a\\u3001\\u88c5\\u5907\\u591a\\u3001\\u6218\\u529f\\u591a\\u3001\\u82f1\\u96c4\\u591a\\uff0c\\u5927\\u5757\\u5403\\u8089\\uff0c\\u5927\\u7897\\u559d\\u9152\\uff0c\\u524d\\u7a0b\\u4f3c\\u9526\\uff0c\\u8d22\\u8fd0\\u4ea8\\u901a\\u3002\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"59\",\"hour\":\"23\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'once', '1', '0', '1359713240', '1360422036', '1360835778', '1360425120', '1360425121', '65', '2'), ('64', 'notice', 'v1.4', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4eb2\\u7231\\u7684\\u73a9\\u5bb6\\uff0c\\u4e3a\\u4e86\\u8425\\u9020\\u4e00\\u4e2a\\u826f\\u597d\\u7684\\u6e38\\u620f\\u73af\\u5883\\uff0c\\u300a\\u6c34\\u6d52\\u82f1\\u96c4\\u300b\\u57281\\u670831\\u65e519\\uff1a00\\u4f1a\\u66f4\\u65b0\\u81f31.4\\u7248\\u672c\\uff0c\\u89e3\\u51b3\\u73b0\\u5b58\\u5728\\u7684bug\\uff0c\\u4e3a\\u4e86\\u8868\\u8fbe\\u6b49\\u610f\\uff0c\\u7279\\u5168\\u670d\\u53d1\\u653e\\u5982\\u610f\\u5b9d\\u5377\\u788e\\u7247*10 +50\\u4f53\\u529b\\uff0c\\u540c\\u65f6\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1359629327', '1359561600', '0', '1359629400', '1359629401', '64', '2'), ('018db2f1-f79d-4b59-bacc-f7002963c674', 'notice', '40服开服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S40\\u3010\\u676f\\u5f13\\u86c7\\u5f71\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"3\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371139863', '1371139900', '1371395505', '1371140340', '0', '33', '-1'), ('9cb3a009-71ce-4afc-bef5-4d13b0859109', 'notice', '40服开服老服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S40\\u3010\\u676f\\u5f13\\u86c7\\u5f71\\u3011\\u4e8e2013\\/06\\/14 10:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"3\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1371139786', '1371139815', '1371190223', '1371140280', '0', '32', '-1'), ('487f46b0-4de1-458e-9848-b1b0b0f96e86', 'notice', '39服开服老服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S39\\u3010\\u5343\\u519b\\u4e07\\u9a6c\\u3011\\u4e8e2013\\/06\\/10 14:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"03\",\"hour\":\"2\",\"day\":\"*\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370827328', '1370793600', '1370877738', '1370827800', '0', '30', '-1'), ('c1bd44e1-f0be-44fb-b12a-a35a9a9499b0', 'notice', '39服开服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S39\\u3010\\u5343\\u519b\\u4e07\\u9a6c\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"3\",\"hour\":\"2\",\"day\":\"*\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '946', '0', '1370827449', '1370827431', '1371052753', '1370827920', '1371052801', '31', '-1'), ('941b4db0-dbfb-4563-8a9d-c1e84feb9e56', 'notice', '38服开服新服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S38\\u3010\\u4e07\\u8c61\\u66f4\\u65b0\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"02\",\"hour\":\"2\",\"day\":\"*\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370530872', '1370530905', '1370790112', '1370531340', '0', '29', '-1'), ('a6e633cf-9557-409b-9f21-500b09ddd137', 'notice', '38服开服老服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\" S38\\u3010\\u4e07\\u8c61\\u66f4\\u65b0\\u3011\\u4e8e2013\\/06\\/07 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"02\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370530785', '1370530800', '1370584805', '1370531220', '0', '28', '-1'), ('08b51696-8b98-4b3f-a834-91adbcddf8aa', 'notice', '2.2版本更新', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4eb2\\u7231\\u5f97\\u6c34\\u6d52\\u82f1\\u96c4\\u4eec\\uff0c\\u671f\\u5f85\\u5df2\\u4e45\\u5f972.2\\u7248\\u672c\\u706b\\u7206\\u6765\\u88ad\\uff0c\\u5b9a\\u4e8e2013\\/06\\/05   09:00\\u8fdb\\u884c\\u66f4\\u65b0\\uff0c\\u8bf7\\u5927\\u5bb6\\u81ea\\u884c\\u524d\\u5f8091\\u66f4\\u65b0\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"2\",\"hour\":\"1\",\"day\":\"*\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370389607', '1370389650', '1370447253', '1370390040', '0', '27', '-1'), ('10e42136-4ca6-4eb6-a738-d6abbf28c85d', 'notice', '37服开服老服通知', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S37\\u3010\\u5927\\u5200\\u9614\\u65a7\\u3011\\u4e8e2013\\/06\\/04 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"05\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370276815', '1370276834', '1370334446', '1370277240', '0', '25', '-1'), ('49c63f7e-2137-4b40-b1c3-e1be64ae8a7c', 'notice', '37服开服新服通知', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S37\\u3010\\u5927\\u5200\\u9614\\u65a7\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"2\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370276903', '1370276936', '1372262340', '1370277420', '0', '26', '-1'), ('8c81d81d-f8a7-46fd-8004-aa527b428303', 'notice', '36服新服开服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S36\\u3010\\u78a7\\u8840\\u4e39\\u5fc3\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"10\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370016339', '1370055964', '1370275156', '1370016840', '0', '24', '-1'), ('4a924d3c-bc7a-4a75-a35d-d124702653e2', 'notice', '36服开服老服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S36\\u3010\\u78a7\\u8840\\u4e39\\u5fc3\\u3011\\u4e8e2013\\/06\\/01 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"10\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1370016227', '1370037600', '1370081017', '1370016600', '0', '23', '-1'), ('84', 'notice', '420', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"4\\u670820\\u65e5\\uff0c\\u65e9\\u66688:00\\uff0c\\u96c5\\u5b89\\u544a\\u6025\\uff0c\\u6570\\u4ee5\\u5343\\u8bb0\\u540c\\u80de\\u9047\\u96be\\uff01\\u5929\\u5730\\u65e0\\u60c5\\u4eba\\u6709\\u60c5\\uff0c\\u4e00\\u65b9\\u6709\\u96be\\u60c5\\u7cfb\\u516b\\u65b9\\uff01\\u8ba9\\u6c34\\u6d52\\u82f1\\u96c4\\u4eec\\u5171\\u540c\\u7948\\u798f\\uff0c\\u613f\\u901d\\u8005\\u5b89\\u606f\\uff0c\\u751f\\u8005\\u575a\\u5f3a\\uff01\\r\\n\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1366473413', '1366473407', '0', '1366473900', '1366473901', '84', '2'), ('7fc53a80-409e-461c-83e4-ca318742495d', 'notice', '35服开服新服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S35\\u3010\\u5355\\u5200\\u8d74\\u4f1a\\u3011\\u4e8e2013\\/05\\/29\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u5f00\\u670d\\u524d\\u4e09\\u5929\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"30\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1369752783', '1369796417', '1370015979', '1369753260', '0', '22', '-1'), ('f6b12281-05e9-4dfd-90cd-93b2aecced2f', 'notice', '35服老服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S35\\u3010\\u5355\\u5200\\u8d74\\u4f1a\\u3011\\u4e8e2013\\/05\\/29 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"30\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1369752670', '1369756806', '1369810282', '1369753080', '0', '21', '-1'), ('8cd8f2ea-6310-4e10-899f-5515886b973f', 'notice', 's1加开阵营战', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u670d\\u52a1\\u5668\\u5c06\\u4e8e2013\\/05\\/27  14:00\\u52a0\\u5f00\\u4e00\\u7ec4\\u9635\\u8425\\u6218\\uff0c\\u8bf7\\u5927\\u5bb6\\u4e92\\u76f8\\u8f6c\\u544a\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"30\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1369620791', '1369584000', '1369634400', '1369620762', '0', '18', '-1'), ('90063cb9-098a-4067-8616-e1c8806f1f3f', 'notice', '34服开服老服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S34\\u3010\\u6597\\u8f6c\\u661f\\u79fb\\u3011\\u4e8e2013\\/05\\/27 18:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\\r\\n\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"30\",\"hour\":\"1\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1369635897', '1369635898', '1369670342', '1369636320', '0', '19', '-1'), ('99071', 'notice', 'sss', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4eb2\\u7231\\u7684\\u73a9\\u5bb6\\uff0c\\u7531\\u4e8e\\u7279\\u6b8a\\u539f\\u56e0\\uff0c\\u670d\\u52a1\\u5668\\u5c06\\u4e8e15:30\\u7d27\\u6025\\u505c\\u670d\\u7ef4\\u62a4\\uff0c\\u5c4a\\u65f6\\u73a9\\u5bb6\\u65e0\\u6cd5\\u767b\\u5165\\u6e38\\u620f\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1368083921', '1368028800', '0', '1368084024', '1368084001', '33', '2'), ('99072', 'notice', 'boss', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4eb2\\u7231\\u7684\\u73a9\\u5bb6\\uff0c5\\u67089\\u53f7\\u7684Boss\\u6218\\u5c06\\u572818\\uff1a00\\u53ca23\\uff1a00\\u5f00\\u542f\\uff0c\\u4e0d\\u4fbf\\u4e4b\\u5904\\uff0c\\u656c\\u8bf7\\u8c05\\u89e3\\u3002\\r\\n\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '0', '0', '1368092466', '1368028800', '0', '1368092494', '0', '0', '0'), ('8', 'notice', 'boss', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"\\u4eb2\\u7231\\u7684\\u73a9\\u5bb6\\uff0c5\\u67089\\u53f7\\u7684Boss\\u6218\\u5c06\\u572818\\uff1a00\\u53ca23\\uff1a00\\u5f00\\u542f\\uff0c\\u4e0d\\u4fbf\\u4e4b\\u5904\\uff0c\\u656c\\u8bf7\\u8c05\\u89e3\\u3002\\r\\n\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1368092645', '1368028800', '0', '1368092803', '1368092761', '35', '2'), ('52e79188-0859-4363-a497-42fafadb9e63', 'notice', '34服新服开服公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S34\\u3010\\u6597\\u8f6c\\u661f\\u79fb\\u3011\\u4e8e2013\\/05\\/27\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u5f00\\u670d\\u524d\\u4e09\\u5929\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"30\",\"hour\":\"2\",\"day\":\"\\uff0a\",\"month\":\"\\uff0a\",\"week\":\"\\uff0a\"}}', 'repeat', '0', '0', '1369636040', '1369636053', '1369843165', '1369636500', '0', '20', '-1'), ('634060', 'notice', 's26-a', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S26\\u3010\\u5578\\u805a\\u5c71\\u6797\\u3011\\u4e8e2013\\/05\\/10\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"15\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '24', '0', '1368119125', '1368119160', '1368291964', '1368119640', '1368288901', '0', '-1'), ('634061', 'notice', 's27', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S27\\u3010\\u5578\\u805a\\u5c71\\u6797\\u3011\\u4e8e2013\\/05\\/12 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"10\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '3', '0', '1368297139', '1368297182', '1368329583', '1368297660', '1368324601', '0', '-1'), ('34ba90ca-2aef-43d0-9b28-355b5b57fc60', 'notice', 'S32【行侠仗义】', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\" S32\\u3010\\u884c\\u4fa0\\u4ed7\\u4e49\\u3011\\u4e8e2013\\/05\\/22 14:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"25\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '12', '0', '1369189175', '1369152000', '1369274400', '1369189560', '1369268701', '40', '-1'), ('9faf86f4-9f96-4fd0-a512-44de73d5e739', 'notice', 'S32【行侠仗义】', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\" S32\\u3010\\u884c\\u4fa0\\u4ed7\\u4e49\\u3011\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"35\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '13', '0', '1369189918', '1369152000', '1369276260', '1369190400', '1369269301', '41', '-1'), ('a57bd988-bd1b-4cda-8848-fa05f85345cc', 'notice', 'test', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"testtesttesttesttesttesttesttesttesttesttest\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"\",\"hour\":\"\",\"day\":\"\",\"month\":\"\",\"week\":\"\"}}', 'once', '1', '0', '1369362963', '1369324800', '0', '1369363115', '1369363081', '42', '2'), ('477d57a4-b512-4d3e-b40b-f3384e7cec59', 'notice', 'testtest', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"testtest\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"13\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '1', '0', '1372176650', '1372176816', '1372180303', '1372177140', '1372176781', '44', '-1'), ('2f3cc3f0-6f52-4b19-a420-991af43b5003', 'notice', '45服开服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S45\\u3010\\u552f\\u6211\\u72ec\\u5c0a\\u3011\\u4e8e2013\\/06\\/29 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"8\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '7', '0', '1372442059', '1372442452', '1372488908', '1372442580', '1372486081', '45', '-1'), ('c26df9ee-f371-479d-a8b5-dc470693406b', 'notice', '44区开服通知', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S44\\u3010\\u9f99\\u98de\\u51e4\\u821e\\u3011\\u4e8e2013\\/06\\/26 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"8\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '6', '0', '1372176327', '1372176526', '1372215367', '1372176780', '1372212481', '42', '-1'), ('b49ccaa8-3a4f-43d8-9af2-4d062b15a5a7', 'notice', '44区冲级通知', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S44\\u3010\\u9f99\\u98de\\u51e4\\u821e\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"20\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '36', '0', '1372176487', '1372216125', '1372435130', '1372176960', '1372429201', '43', '-1'), ('c4f55412-a6b2-4ddd-bae4-fd9bfc883d60', 'notice', '45服冲级公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S45\\u3010\\u552f\\u6211\\u72ec\\u5c0a\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"7\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '24', '0', '1372442162', '1372442667', '1372615017', '1372442640', '1372608421', '46', '-1'), ('fab83b6e-99eb-47da-ae44-84eb81557bc9', 'notice', '46服开服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S46\\u3010\\u820d\\u751f\\u5fd8\\u6b7b\\u3011\\u4e8e2013\\/07\\/04 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"9\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '7', '0', '1372870779', '1372872613', '1372921225', '1372871280', '1372918141', '47', '-1'), ('4ba9b551-5f8f-4e1f-81a3-efda5e383435', 'notice', '46服冲击公告', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S46\\u3010\\u820d\\u751f\\u5fd8\\u6b7b\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"6\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '35', '0', '1372870870', '1372906910', '1373124657', '1372871340', '1373119561', '48', '-1'), ('8da45b80-befc-4a4c-9636-d015eb1e6639', 'notice', '47服开服播报', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S47\\u3010\\u4e07\\u592b\\u4e0d\\u5f53\\u3011\\u4e8e2013\\/07\\/09 11:00\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u8bf7\\u73a9\\u5bb6\\u76f8\\u4e92\\u8f6c\\u544a\\uff0c\\u795d\\u5927\\u5bb6\\u6e38\\u620f\\u6109\\u5feb\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"6\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '7', '0', '1373302983', '1373304653', '1373353442', '1373303460', '1373349961', '49', '-1'), ('ea7d0f3b-9b69-4bbc-a65b-c2256445994b', 'notice', '47服冲级奖励', '', '{\"channel\":\"1\",\"receiver_id\":\"0\",\"msg\":\"S47\\u3010\\u4e07\\u592b\\u4e0d\\u5f53\\u3011\\u73b0\\u5df2\\u706b\\u7206\\u5f00\\u542f\\uff0c\\u66f4\\u591a\\u65b0\\u670d\\u9650\\u65f6\\u6d3b\\u52a8\\u7b49\\u4f60\\u6765\\u53c2\\u52a0\\uff0c\\u51b2\\u7ea7\\u5927\\u793c\\u4e0d\\u5bb9\\u9519\\u8fc7\\uff0c\\u7b2c\\u4e00\\u540d\\uff1a3000\\u6218\\u529f\\uff0c500W\\u94dc\\u94b1\\uff0c200\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e8c\\u540d\\uff1a2000\\u6218\\u529f\\uff0c300W\\u94dc\\u94b1\\uff0c100\\u70b9\\u4f53\\u529b\\uff1b\\u7b2c\\u4e09\\u540d\\uff1a1000\\u6218\\u529f\\uff0c200W\\u94dc\\u94b1\\uff0c50\\u70b9\\u4f53\\u529b\\uff1b\\u8d76\\u7d27\\u884c\\u52a8\\u5427\\uff01\",\"module\":\"\",\"method\":\"index\",\"url\":\"\",\"crontime\":{\"minute\":\"7\",\"hour\":\"*\\/2\",\"day\":\"*\",\"month\":\"*\",\"week\":\"*\"}}', 'repeat', '36', '0', '1373303093', '1373335550', '1373562364', '1373303580', '1373558821', '50', '-1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_currency`
-- ----------------------------
DROP TABLE IF EXISTS `ks_currency`;
CREATE TABLE `ks_currency` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL COMMENT '币种名称',
  `code` varchar(10) NOT NULL COMMENT '货币英文简称',
  `symbol` varchar(30) NOT NULL COMMENT '货币英文符号',
  `rate` float(5,0) NOT NULL DEFAULT '1' COMMENT '与人民币之间的汇率',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='币种表';

-- ----------------------------
--  Records of `ks_currency`
-- ----------------------------
BEGIN;
INSERT INTO `ks_currency` VALUES ('1', '人民币', 'CNY', '￥', '1'), ('2', '美元', 'USD', '$', '1'), ('3', '港币', 'HKD', 'HK＄', '1'), ('4', '欧元', 'EUR', '€', '1'), ('5', '日元', 'JPY', '￥', '1'), ('6', '英镑', 'GBP', '￡', '1'), ('7', '加拿大元', 'CAD', 'cad', '1'), ('8', '瑞士法郎', 'CHF', 'chf', '1'), ('9', '澳大利亚元', 'AUD', 'aud', '1'), ('10', '新加坡元', 'SGD', 'sgd', '1'), ('11', '新台币', 'NTB', 'ntb', '1'), ('12', '丹麦克朗', 'DKK', 'dkk', '1'), ('13', '挪威克朗', 'NOK', 'nok', '1'), ('14', '瑞典克朗', 'SEK', 'sek', '1'), ('15', '澳门元', 'MOP', 'mop', '1'), ('16', '新西兰元', 'NZD', 'nzd', '1'), ('17', '韩元', 'KRW', 'krw', '1'), ('18', '马克', 'DEM', 'dem', '1'), ('19', '法国法郎', 'FAF', 'faf', '1'), ('20', '智利比索', 'CLP', 'clp', '1'), ('21', '迪拉姆', 'AED', 'AED', '1'), ('22', '马元', 'MYR', 'MYR', '1'), ('23', '泰铢', 'THP', 'THP', '1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_day`
-- ----------------------------
DROP TABLE IF EXISTS `ks_day`;
CREATE TABLE `ks_day` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `type` varchar(30) NOT NULL DEFAULT '' COMMENT '类型',
  `memo` varchar(250) NOT NULL DEFAULT '' COMMENT '备注',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=707 DEFAULT CHARSET=utf8 COMMENT='会员每日领取表';

-- ----------------------------
--  Table structure for `ks_diary`
-- ----------------------------
DROP TABLE IF EXISTS `ks_diary`;
CREATE TABLE `ks_diary` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT '记录唯一标识',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '日记分类',
  `title` varchar(100) NOT NULL COMMENT '日记标题',
  `content` text NOT NULL COMMENT '日记内容',
  `star` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否星标',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后修改时间',
  `family` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '家庭组是否可以查看',
  `state` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='日记表';

-- ----------------------------
--  Table structure for `ks_family`
-- ----------------------------
DROP TABLE IF EXISTS `ks_family`;
CREATE TABLE `ks_family` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL COMMENT '家庭创建人',
  `name` varchar(30) NOT NULL COMMENT '家庭名称',
  `desc` varchar(250) NOT NULL COMMENT '家庭描述',
  `members` varchar(1000) NOT NULL DEFAULT '1' COMMENT '成员信息',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '家庭创建时间',
  `uuid` varchar(32) NOT NULL DEFAULT '' COMMENT '家庭唯一标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='会员家庭信息表';

-- ----------------------------
--  Records of `ks_family`
-- ----------------------------
BEGIN;
INSERT INTO `ks_family` VALUES ('7', '18', '测试家庭', '这是一个测试家庭,你可以通过FID加入这个家庭', '2', '4294967295', '7a0e760d-f5ce-4c78-aa94-86b6e00a');
COMMIT;

-- ----------------------------
--  Table structure for `ks_feedback`
-- ----------------------------
DROP TABLE IF EXISTS `ks_feedback`;
CREATE TABLE `ks_feedback` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `url` varchar(100) NOT NULL DEFAULT '' COMMENT '类型',
  `content` text NOT NULL COMMENT '备注',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`url`)
) ENGINE=MyISAM AUTO_INCREMENT=709 DEFAULT CHARSET=utf8 COMMENT='会员每日领取表';

-- ----------------------------
--  Table structure for `ks_friend`
-- ----------------------------
DROP TABLE IF EXISTS `ks_friend`;
CREATE TABLE `ks_friend` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(10) unsigned NOT NULL COMMENT '当前用户id',
  `friend_id` int(10) unsigned NOT NULL COMMENT '朋友用户id',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间 或 通过好友申请时间',
  `state` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '状态 0等待添加好友 1完成并同意添加好友',
  PRIMARY KEY (`id`),
  KEY `user_friend_id` (`user_id`,`friend_id`)
) ENGINE=MyISAM AUTO_INCREMENT=196 DEFAULT CHARSET=utf8 COMMENT='会员好友表';

-- ----------------------------
--  Table structure for `ks_invite`
-- ----------------------------
DROP TABLE IF EXISTS `ks_invite`;
CREATE TABLE `ks_invite` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '邀请人',
  `invite_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '被邀请人',
  `createtime` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `ip` varchar(32) NOT NULL DEFAULT '' COMMENT 'IP',
  `referer` varchar(250) NOT NULL DEFAULT '' COMMENT '来源URL',
  `state` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '被邀请人状态',
  PRIMARY KEY (`id`),
  KEY `createtime` (`createtime`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='会员邀请表';

-- ----------------------------
--  Table structure for `ks_login_failure`
-- ----------------------------
DROP TABLE IF EXISTS `ks_login_failure`;
CREATE TABLE `ks_login_failure` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `username` varchar(100) DEFAULT NULL COMMENT '尝试用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '尝试密码',
  `intro` varchar(100) DEFAULT NULL COMMENT '错误描述',
  `ip` varchar(100) DEFAULT NULL COMMENT 'IP地址',
  `createtime` int(10) DEFAULT NULL COMMENT '登录时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=730 DEFAULT CHARSET=utf8 COMMENT='登录失败信息表';

-- ----------------------------
--  Records of `ks_login_failure`
-- ----------------------------
BEGIN;
INSERT INTO `ks_login_failure` VALUES ('728', 'karson', 'karson', '用户名或密码出错', '127.0.0.1', '1425696589'), ('729', 'karson', '123456', '用户名或密码出错', '127.0.0.1', '1425696598');
COMMIT;

-- ----------------------------
--  Table structure for `ks_note`
-- ----------------------------
DROP TABLE IF EXISTS `ks_note`;
CREATE TABLE `ks_note` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(10) NOT NULL DEFAULT '0',
  `from_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0为系统消息 1为会员消息',
  `type` varchar(30) NOT NULL DEFAULT 'person' COMMENT '类型',
  `content` text NOT NULL COMMENT '短信内容',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发送时间',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1已读 0未读 -1已删除',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=13166 DEFAULT CHARSET=utf8 COMMENT='会员短信息表';

-- ----------------------------
--  Table structure for `ks_notice`
-- ----------------------------
DROP TABLE IF EXISTS `ks_notice`;
CREATE TABLE `ks_notice` (
  `id` int(10) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(250) NOT NULL COMMENT '公告标题',
  `color` varchar(10) NOT NULL DEFAULT '' COMMENT '公告颜色',
  `author` varchar(30) NOT NULL DEFAULT '' COMMENT '发布人',
  `content` text NOT NULL COMMENT '公告内容',
  `version` varchar(500) NOT NULL DEFAULT '' COMMENT '允许出现的版本号',
  `views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览次数',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公告发布时间',
  `starttime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公告开始时间',
  `expiretime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '公告过期时间',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '权重',
  `state` tinyint(1) NOT NULL COMMENT '公告状态',
  PRIMARY KEY (`id`),
  KEY `pf` (`title`)
) ENGINE=MyISAM AUTO_INCREMENT=1474 DEFAULT CHARSET=utf8 COMMENT='分区玩家session登录表';

-- ----------------------------
--  Table structure for `ks_reply`
-- ----------------------------
DROP TABLE IF EXISTS `ks_reply`;
CREATE TABLE `ks_reply` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL COMMENT '会员ID',
  `thread_id` int(10) unsigned NOT NULL COMMENT '贴子ID',
  `nickname` varchar(30) NOT NULL COMMENT '回帖会员的昵称',
  `content` text NOT NULL COMMENT '回帖内容',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改时间',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `thread_id` (`thread_id`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='论坛回帖表';

-- ----------------------------
--  Table structure for `ks_role`
-- ----------------------------
DROP TABLE IF EXISTS `ks_role`;
CREATE TABLE `ks_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `father_id` int(10) NOT NULL DEFAULT '0' COMMENT '权限父ID',
  `name` varchar(30) NOT NULL COMMENT '角色名称',
  `rank` int(10) NOT NULL DEFAULT '0' COMMENT '角色权限等级',
  `permission` text NOT NULL COMMENT '角色权限',
  `createtime` int(10) NOT NULL COMMENT '角色创建时间',
  `modifytime` int(10) NOT NULL COMMENT '角色修改时间',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
--  Records of `ks_role`
-- ----------------------------
BEGIN;
INSERT INTO `ks_role` VALUES ('1', '0', '技术研发部', '100', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";N;}', '1342078550', '1366104855'), ('2', '5', '商务部', '98', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";a:6:{i:0;s:7:\"general\";s:7:\"general\";a:25:{i:0;s:4:\"main\";i:1;s:6:\"config\";s:6:\"config\";a:3:{i:0;s:5:\"index\";i:1;s:4:\"edit\";i:2;s:7:\"restore\";}i:2;s:5:\"basic\";i:3;s:7:\"crontab\";s:7:\"crontab\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:4;s:8:\"database\";s:8:\"database\";a:4:{i:0;s:5:\"index\";i:1;s:7:\"browser\";i:2;s:6:\"repair\";i:3;s:7:\"execute\";}i:5;s:11:\"configvalue\";s:11:\"configvalue\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:6;s:7:\"formula\";s:7:\"formula\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:7;s:3:\"vip\";s:3:\"vip\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:8;s:4:\"logs\";i:9;s:8:\"language\";s:8:\"language\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:10;s:8:\"personal\";i:11;s:8:\"checkenv\";i:12;s:7:\"version\";s:7:\"version\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:13;s:6:\"search\";i:14;s:6:\"notice\";s:6:\"notice\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:15;s:5:\"cache\";}i:1;s:4:\"user\";s:4:\"user\";a:2:{i:0;s:4:\"user\";s:4:\"user\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:5:\"basic\";}}i:2;s:4:\"role\";s:4:\"role\";a:6:{i:0;s:4:\"role\";s:4:\"role\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:5:\"admin\";s:5:\"admin\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:3:\"log\";s:3:\"log\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}}}', '1366105206', '1367044286'), ('3', '5', '运营中心', '50', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";a:26:{i:0;s:7:\"general\";s:7:\"general\";a:12:{i:0;s:4:\"main\";i:1;s:6:\"config\";s:6:\"config\";a:3:{i:0;s:5:\"index\";i:1;s:4:\"edit\";i:2;s:7:\"restore\";}i:2;s:7:\"crontab\";s:7:\"crontab\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:3;s:8:\"personal\";i:4;s:7:\"version\";s:7:\"version\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:5;s:6:\"search\";i:6;s:6:\"notice\";s:6:\"notice\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:7;s:5:\"cache\";}i:1;s:4:\"user\";s:4:\"user\";a:12:{i:0;s:4:\"user\";s:4:\"user\";a:6:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";i:4;s:5:\"basic\";i:5;s:6:\"medium\";}i:1;s:5:\"order\";s:5:\"order\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:2;s:4:\"rank\";s:4:\"rank\";a:1:{i:0;s:5:\"index\";}i:3;s:4:\"mail\";s:4:\"mail\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:4;s:8:\"question\";s:8:\"question\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:5;s:4:\"chat\";s:4:\"chat\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}}i:2;s:3:\"log\";s:3:\"log\";a:10:{i:0;s:5:\"error\";s:5:\"error\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:8:\"resource\";s:8:\"resource\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:4:\"gold\";s:4:\"gold\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:3;s:8:\"industry\";s:8:\"industry\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:4;s:5:\"slave\";s:5:\"slave\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:3;s:4:\"area\";s:4:\"area\";a:6:{i:0;s:4:\"area\";s:4:\"area\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:1;s:8:\"realtime\";s:8:\"realtime\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:10:\"statistics\";s:10:\"statistics\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:4;s:7:\"channel\";s:7:\"channel\";a:6:{i:0;s:7:\"channel\";s:7:\"channel\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:7:\"account\";s:7:\"account\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:10:\"statistics\";s:10:\"statistics\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:5;s:5:\"order\";s:5:\"order\";a:8:{i:0;s:5:\"order\";s:5:\"order\";a:1:{i:0;s:5:\"index\";}i:1;s:8:\"recharge\";s:8:\"recharge\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:2;s:4:\"logs\";s:4:\"logs\";a:1:{i:0;s:5:\"index\";}i:3;s:10:\"statistics\";s:10:\"statistics\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}}i:6;s:7:\"account\";s:7:\"account\";a:4:{i:0;s:7:\"account\";s:7:\"account\";a:2:{i:0;s:5:\"index\";i:1;s:4:\"edit\";}i:1;s:4:\"user\";s:4:\"user\";a:2:{i:0;s:5:\"index\";i:1;s:4:\"edit\";}}i:7;s:4:\"push\";s:4:\"push\";a:6:{i:0;s:4:\"push\";s:4:\"push\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:6:\"device\";s:6:\"device\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:7:\"message\";s:7:\"message\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:8;s:10:\"invitecard\";s:10:\"invitecard\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:9;s:5:\"store\";s:5:\"store\";a:4:{i:0;s:5:\"store\";s:5:\"store\";a:1:{i:0;s:5:\"index\";}i:1;s:13:\"discountstore\";s:13:\"discountstore\";a:1:{i:0;s:5:\"index\";}}i:10;s:4:\"mail\";s:4:\"mail\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:11;s:8:\"analysis\";s:8:\"analysis\";a:4:{i:0;s:4:\"gold\";s:4:\"gold\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:4:\"task\";s:4:\"task\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:12;s:4:\"role\";s:4:\"role\";a:6:{i:0;s:4:\"role\";s:4:\"role\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:5:\"admin\";s:5:\"admin\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:3:\"log\";s:3:\"log\";a:1:{i:0;s:5:\"index\";}}}}', '1368070135', '1372327466'), ('4', '0', '客服001', '50', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";a:6:{i:0;s:7:\"general\";s:7:\"general\";a:6:{i:0;s:4:\"main\";i:1;s:8:\"personal\";i:2;s:6:\"search\";i:3;s:6:\"notice\";s:6:\"notice\";a:1:{i:0;s:5:\"index\";}i:4;s:5:\"cache\";}i:1;s:4:\"user\";s:4:\"user\";a:4:{i:0;s:8:\"question\";s:8:\"question\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:1;s:4:\"chat\";s:4:\"chat\";a:1:{i:0;s:5:\"index\";}}i:2;s:7:\"account\";s:7:\"account\";a:4:{i:0;s:7:\"account\";s:7:\"account\";a:1:{i:0;s:5:\"index\";}i:1;s:4:\"user\";s:4:\"user\";a:1:{i:0;s:5:\"index\";}}}}', '1368607128', '1372216673'), ('5', '5', '内部GM', '50', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";a:18:{i:0;s:7:\"general\";s:7:\"general\";a:14:{i:0;s:4:\"main\";i:1;s:6:\"config\";s:6:\"config\";a:3:{i:0;s:5:\"index\";i:1;s:4:\"edit\";i:2;s:7:\"restore\";}i:2;s:7:\"crontab\";s:7:\"crontab\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:3;s:3:\"vip\";s:3:\"vip\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:4;s:8:\"personal\";i:5;s:7:\"version\";s:7:\"version\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:6;s:6:\"search\";i:7;s:6:\"notice\";s:6:\"notice\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:8;s:5:\"cache\";}i:1;s:4:\"user\";s:4:\"user\";a:48:{i:0;s:4:\"user\";s:4:\"user\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:5:\"basic\";}i:1;s:5:\"order\";s:5:\"order\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:2;s:4:\"hero\";s:4:\"hero\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:3;s:4:\"item\";s:4:\"item\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:4;s:4:\"task\";s:4:\"task\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:5;s:8:\"suppress\";s:8:\"suppress\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:6;s:4:\"rank\";s:4:\"rank\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:7;s:5:\"stage\";s:5:\"stage\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:8;s:5:\"point\";s:5:\"point\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:9;s:3:\"gem\";s:3:\"gem\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:10;s:6:\"tattoo\";s:6:\"tattoo\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:11;s:8:\"industry\";s:8:\"industry\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:12;s:8:\"guessnum\";s:8:\"guessnum\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:13;s:6:\"signin\";s:6:\"signin\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:14;s:5:\"slave\";s:5:\"slave\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:15;s:4:\"mail\";s:4:\"mail\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:16;s:8:\"question\";s:8:\"question\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:17;s:3:\"day\";s:3:\"day\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:18;s:8:\"activity\";s:8:\"activity\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:19;s:13:\"limitactivity\";s:13:\"limitactivity\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:20;s:4:\"chat\";s:4:\"chat\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:21;s:4:\"gang\";s:4:\"gang\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:22;s:4:\"maze\";s:4:\"maze\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:23;s:6:\"knight\";s:6:\"knight\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}}i:2;s:3:\"log\";s:3:\"log\";a:16:{i:0;s:5:\"error\";s:5:\"error\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:1;s:8:\"resource\";s:8:\"resource\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:2;s:4:\"gold\";s:4:\"gold\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:3;s:8:\"industry\";s:8:\"industry\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:4;s:5:\"slave\";s:5:\"slave\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:5;s:4:\"good\";s:4:\"good\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:6;s:5:\"point\";s:5:\"point\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:7;s:4:\"item\";s:4:\"item\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}}i:3;s:7:\"account\";s:7:\"account\";a:4:{i:0;s:7:\"account\";s:7:\"account\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:1;s:4:\"user\";s:4:\"user\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}}i:4;s:6:\"reward\";s:6:\"reward\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:5;s:4:\"gang\";s:4:\"gang\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:6;s:4:\"item\";s:4:\"item\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:7;s:5:\"store\";s:5:\"store\";a:4:{i:0;s:5:\"store\";s:5:\"store\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:13:\"discountstore\";s:13:\"discountstore\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:8;s:4:\"mail\";s:4:\"mail\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}}}', '1370770277', '1370770342'), ('6', '5', '测试部', '50', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";a:6:{i:0;s:7:\"general\";s:7:\"general\";a:1:{i:0;s:4:\"main\";}i:1;s:4:\"user\";s:4:\"user\";a:2:{i:0;s:4:\"user\";s:4:\"user\";a:7:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";i:4;s:5:\"basic\";i:5;s:6:\"medium\";i:6;s:7:\"advance\";}}i:2;s:5:\"order\";s:5:\"order\";a:2:{i:0;s:8:\"recharge\";s:8:\"recharge\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}}}}', '1369212837', '1371632926'), ('7', '0', '数据人员', '50', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";a:14:{i:0;s:7:\"general\";s:7:\"general\";a:2:{i:0;s:4:\"main\";i:1;s:8:\"personal\";}i:1;s:4:\"user\";s:4:\"user\";a:4:{i:0;s:4:\"user\";s:4:\"user\";a:1:{i:0;s:5:\"index\";}i:1;s:5:\"order\";s:5:\"order\";a:1:{i:0;s:5:\"index\";}}i:2;s:3:\"log\";s:3:\"log\";a:8:{i:0;s:8:\"resource\";s:8:\"resource\";a:1:{i:0;s:5:\"index\";}i:1;s:4:\"gold\";s:4:\"gold\";a:1:{i:0;s:5:\"index\";}i:2;s:8:\"industry\";s:8:\"industry\";a:1:{i:0;s:5:\"index\";}i:3;s:5:\"slave\";s:5:\"slave\";a:1:{i:0;s:5:\"index\";}}i:3;s:4:\"area\";s:4:\"area\";a:6:{i:0;s:4:\"area\";s:4:\"area\";a:1:{i:0;s:5:\"index\";}i:1;s:8:\"realtime\";s:8:\"realtime\";a:1:{i:0;s:5:\"index\";}i:2;s:10:\"statistics\";s:10:\"statistics\";a:1:{i:0;s:5:\"index\";}}i:4;s:5:\"order\";s:5:\"order\";a:6:{i:0;s:5:\"order\";s:5:\"order\";a:1:{i:0;s:5:\"index\";}i:1;s:4:\"logs\";s:4:\"logs\";a:1:{i:0;s:5:\"index\";}i:2;s:10:\"statistics\";s:10:\"statistics\";a:1:{i:0;s:5:\"index\";}}i:5;s:7:\"account\";s:7:\"account\";a:4:{i:0;s:7:\"account\";s:7:\"account\";a:1:{i:0;s:5:\"index\";}i:1;s:4:\"user\";s:4:\"user\";a:1:{i:0;s:5:\"index\";}}i:6;s:8:\"analysis\";s:8:\"analysis\";a:4:{i:0;s:4:\"gold\";s:4:\"gold\";a:1:{i:0;s:5:\"index\";}i:1;s:4:\"task\";s:4:\"task\";a:1:{i:0;s:5:\"index\";}}}}', '1370486654', '1370773153'), ('10', '0', '小运营', '50', 'a:3:{s:9:\"allow_uri\";a:1:{i:0;s:0:\"\";}s:8:\"deny_uri\";a:1:{i:0;s:0:\"\";}s:5:\"admin\";a:22:{i:0;s:7:\"general\";s:7:\"general\";a:12:{i:0;s:4:\"main\";i:1;s:6:\"config\";s:6:\"config\";a:3:{i:0;s:5:\"index\";i:1;s:4:\"edit\";i:2;s:7:\"restore\";}i:2;s:7:\"crontab\";s:7:\"crontab\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:3;s:8:\"personal\";i:4;s:7:\"version\";s:7:\"version\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:5;s:6:\"search\";i:6;s:6:\"notice\";s:6:\"notice\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:7;s:5:\"cache\";}i:1;s:4:\"user\";s:4:\"user\";a:12:{i:0;s:4:\"user\";s:4:\"user\";a:6:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";i:4;s:5:\"basic\";i:5;s:6:\"medium\";}i:1;s:5:\"order\";s:5:\"order\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:2;s:4:\"rank\";s:4:\"rank\";a:1:{i:0;s:5:\"index\";}i:3;s:4:\"mail\";s:4:\"mail\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:4;s:8:\"question\";s:8:\"question\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:5;s:4:\"chat\";s:4:\"chat\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}}i:2;s:3:\"log\";s:3:\"log\";a:10:{i:0;s:5:\"error\";s:5:\"error\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:8:\"resource\";s:8:\"resource\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:4:\"gold\";s:4:\"gold\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:3;s:8:\"industry\";s:8:\"industry\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:4;s:5:\"slave\";s:5:\"slave\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:3;s:4:\"area\";s:4:\"area\";a:6:{i:0;s:4:\"area\";s:4:\"area\";a:3:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";}i:1;s:8:\"realtime\";s:8:\"realtime\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:10:\"statistics\";s:10:\"statistics\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:4;s:7:\"channel\";s:7:\"channel\";a:6:{i:0;s:7:\"channel\";s:7:\"channel\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:7:\"account\";s:7:\"account\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:10:\"statistics\";s:10:\"statistics\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:5;s:5:\"order\";s:5:\"order\";a:8:{i:0;s:5:\"order\";s:5:\"order\";a:1:{i:0;s:5:\"index\";}i:1;s:8:\"recharge\";s:8:\"recharge\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:2;s:4:\"logs\";s:4:\"logs\";a:1:{i:0;s:5:\"index\";}i:3;s:10:\"statistics\";s:10:\"statistics\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}}i:6;s:7:\"account\";s:7:\"account\";a:4:{i:0;s:7:\"account\";s:7:\"account\";a:2:{i:0;s:5:\"index\";i:1;s:4:\"edit\";}i:1;s:4:\"user\";s:4:\"user\";a:2:{i:0;s:5:\"index\";i:1;s:4:\"edit\";}}i:7;s:4:\"push\";s:4:\"push\";a:6:{i:0;s:4:\"push\";s:4:\"push\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:6:\"device\";s:6:\"device\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:2;s:7:\"message\";s:7:\"message\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}i:8;s:10:\"invitecard\";s:10:\"invitecard\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:9;s:4:\"mail\";s:4:\"mail\";a:2:{i:0;s:5:\"index\";i:1;s:3:\"add\";}i:10;s:8:\"analysis\";s:8:\"analysis\";a:4:{i:0;s:4:\"gold\";s:4:\"gold\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}i:1;s:4:\"task\";s:4:\"task\";a:4:{i:0;s:5:\"index\";i:1;s:3:\"add\";i:2;s:4:\"edit\";i:3;s:3:\"del\";}}}}', '1372325739', '1373526302');
COMMIT;

-- ----------------------------
--  Table structure for `ks_scores`
-- ----------------------------
DROP TABLE IF EXISTS `ks_scores`;
CREATE TABLE `ks_scores` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL DEFAULT '0',
  `scores` double(10,0) NOT NULL DEFAULT '0',
  `reason` varchar(250) NOT NULL DEFAULT '',
  `operator` varchar(100) NOT NULL DEFAULT '',
  `createtime` int(10) NOT NULL DEFAULT '0',
  `ip` varchar(32) NOT NULL DEFAULT '' COMMENT 'IP',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=11297 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `ks_session`
-- ----------------------------
DROP TABLE IF EXISTS `ks_session`;
CREATE TABLE `ks_session` (
  `sid` varchar(40) NOT NULL DEFAULT '0' COMMENT '唯一SESSIONID',
  `ip` varchar(16) NOT NULL DEFAULT '0' COMMENT '用户IP',
  `user_agent` varchar(150) NOT NULL COMMENT '用户客户端信息',
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后一次活动时间',
  `expire` int(10) NOT NULL COMMENT '过期时间',
  `data` text NOT NULL COMMENT 'SESSION数据',
  PRIMARY KEY (`sid`),
  KEY `expiretime` (`expire`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='SESSION表';

-- ----------------------------
--  Records of `ks_session`
-- ----------------------------
BEGIN;
INSERT INTO `ks_session` VALUES ('gpghv72mao8tvcpqkirt87dni1', '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/42.0.2311.22 Safari/537.36', '1425911248', '1425914848', '');
COMMIT;

-- ----------------------------
--  Table structure for `ks_task`
-- ----------------------------
DROP TABLE IF EXISTS `ks_task`;
CREATE TABLE `ks_task` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '记录主键',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `type` enum('income','expense','transfer','borrow','credit') NOT NULL DEFAULT 'expense' COMMENT '类型',
  `category_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '分类ID,1,2,3,4分别为借出,借入,还入,还出',
  `account_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '操作账户ID',
  `inaccount_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '收入账户ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '消费名称',
  `amount` float(10,2) NOT NULL DEFAULT '0.00' COMMENT '金额',
  `memo` varchar(250) NOT NULL DEFAULT '' COMMENT '说明',
  `family` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '家庭组是否可以查看',
  `nums` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '已执行次数',
  `maxnums` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最大执行次数',
  `frequency` varchar(30) NOT NULL DEFAULT 'day' COMMENT '重复频率',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '记录添加时间',
  `executetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后运行时间',
  `expiretime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '过期时间',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态 -2已结束 -1已过期 0禁用 1正常',
  `uuid` varchar(36) NOT NULL DEFAULT '' COMMENT '记录唯一标识',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`,`account_id`,`category_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='账目表';

-- ----------------------------
--  Table structure for `ks_thread`
-- ----------------------------
DROP TABLE IF EXISTS `ks_thread`;
CREATE TABLE `ks_thread` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL COMMENT '会员ID',
  `category_id` int(10) unsigned NOT NULL COMMENT '帖子分类',
  `nickname` varchar(30) NOT NULL COMMENT '发贴人',
  `title` varchar(100) NOT NULL COMMENT '帖子标题',
  `content` text NOT NULL COMMENT '主贴内容',
  `flag` set('hot','commend','top') NOT NULL DEFAULT '',
  `views` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '浏览数',
  `weigh` int(10) NOT NULL DEFAULT '0' COMMENT '帖子权重',
  `replies` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '回帖数',
  `createtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `modifytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '修改日期',
  `replytime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后回复时间',
  `lastreply` varchar(100) NOT NULL DEFAULT '' COMMENT '最后发表的用户信息',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='论坛帖子表';

-- ----------------------------
--  Records of `ks_thread`
-- ----------------------------
BEGIN;
INSERT INTO `ks_thread` VALUES ('48', '18', '3', 'test', 'fdsfadfafdsfdsafsa', 'fadadfdasfdasfdasfdsfdsaads', '', '1', '0', '0', '1425696969', '0', '1425696969', '', '1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_uploads`
-- ----------------------------
DROP TABLE IF EXISTS `ks_uploads`;
CREATE TABLE `ks_uploads` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `channel` tinyint(1) NOT NULL DEFAULT '0' COMMENT '频道',
  `user_id` int(10) NOT NULL DEFAULT '0' COMMENT '会员',
  `type` varchar(30) NOT NULL COMMENT '资源类型',
  `aid` int(10) NOT NULL DEFAULT '0' COMMENT '文档ID',
  `url` varchar(100) NOT NULL DEFAULT '0',
  `size` int(10) NOT NULL DEFAULT '0' COMMENT '文件大小',
  `width` mediumint(8) NOT NULL DEFAULT '0' COMMENT '图片宽度',
  `height` mediumint(8) NOT NULL DEFAULT '0' COMMENT '图片高度',
  `downloads` int(10) NOT NULL DEFAULT '0' COMMENT '下载次数',
  `createtime` int(11) NOT NULL DEFAULT '0' COMMENT '来访时间',
  PRIMARY KEY (`id`),
  KEY `createtime` (`createtime`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=15504 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `ks_user`
-- ----------------------------
DROP TABLE IF EXISTS `ks_user`;
CREATE TABLE `ks_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色ID',
  `title_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '称号ID',
  `family_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '家庭组ID',
  `username` varchar(32) NOT NULL DEFAULT '' COMMENT '姓名',
  `nickname` varchar(32) NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(32) NOT NULL DEFAULT '' COMMENT '登入密码',
  `email` varchar(100) NOT NULL DEFAULT '' COMMENT 'Email地址',
  `gender` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户性别',
  `face` varchar(120) NOT NULL DEFAULT '' COMMENT '头像',
  `city_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '城市ID',
  `activetime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后活动时间',
  `lastsessionid` varchar(32) NOT NULL DEFAULT '' COMMENT '登录SESSION',
  `state` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `city_id` (`city_id`),
  KEY `activetime` (`activetime`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户信息基础表';

-- ----------------------------
--  Records of `ks_user`
-- ----------------------------
BEGIN;
INSERT INTO `ks_user` VALUES ('18', '10', '0', '7', 'test', 'test', '13ce383d4a890de5d36f73c5fcdc0605', 'test@test.com', '0', '', '0', '0', 'pbdb64p9vml27jljn79q47dqf7', '1'), ('19', '10', '0', '0', 'karson', 'karson', '99450b4842b533c79d5d2d1d4d8e65c5', 'karsonzhang@163.com', '0', '', '0', '0', 'vo4ipj39rle71020g9lq944jl6', '1'), ('20', '10', '0', '7', 'test2', 'test2', 'fd909c7635e377752e41b2a737b64c40', 'test2@test.com', '0', '44_0_100', '0', '0', 'vo4ipj39rle71020g9lq944jl6', '1');
COMMIT;

-- ----------------------------
--  Table structure for `ks_user_count`
-- ----------------------------
DROP TABLE IF EXISTS `ks_user_count`;
CREATE TABLE `ks_user_count` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '会员ID',
  `successions` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '连续多少天登录',
  `logins` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '总登录数',
  `invites` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '邀请人数',
  `friends` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '总好友数量',
  `messages` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '留言数',
  `notes` mediumint(6) unsigned NOT NULL DEFAULT '0' COMMENT '信息数',
  `signins` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '签到次数',
  `scores` int(10) NOT NULL DEFAULT '0' COMMENT '积分',
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员统计表';

-- ----------------------------
--  Records of `ks_user_count`
-- ----------------------------
BEGIN;
INSERT INTO `ks_user_count` VALUES ('18', '1', '6', '0', '0', '0', '0', '0', '0'), ('19', '1', '2', '0', '0', '0', '0', '0', '0'), ('20', '1', '2', '0', '0', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
--  Table structure for `ks_user_extension`
-- ----------------------------
DROP TABLE IF EXISTS `ks_user_extension`;
CREATE TABLE `ks_user_extension` (
  `user_id` int(10) unsigned NOT NULL COMMENT '用户id',
  `jointime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '加入时间',
  `joinip` varchar(32) NOT NULL DEFAULT '' COMMENT '加入IP',
  `logintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '本次登录时间',
  `loginip` varchar(32) NOT NULL DEFAULT '' COMMENT '本次登录IP',
  `lastlogintime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上次登录时间',
  `lastloginip` varchar(32) NOT NULL DEFAULT '0' COMMENT '上次登录IP',
  `signature` varchar(100) NOT NULL DEFAULT '' COMMENT '签名',
  `homepage` varchar(100) NOT NULL,
  `birthday` date NOT NULL DEFAULT '0000-00-00' COMMENT '出生日期',
  `location` varchar(50) NOT NULL,
  `introduce` varchar(250) NOT NULL,
  `pagesize` int(10) unsigned NOT NULL DEFAULT '20' COMMENT '分页大小',
  `notice` varchar(250) NOT NULL DEFAULT '' COMMENT '后台通知',
  `referer` varchar(250) NOT NULL DEFAULT '',
  PRIMARY KEY (`user_id`),
  KEY `jointime` (`jointime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='会员扩展信息表';

-- ----------------------------
--  Records of `ks_user_extension`
-- ----------------------------
BEGIN;
INSERT INTO `ks_user_extension` VALUES ('18', '1375286064', '127.0.0.1', '1425696601', '127.0.0.1', '1375287119', '127.0.0.1', '', '', '0000-00-00', '', '', '20', '', 'http://127.0.0.3/user/face/'), ('19', '1375286455', '127.0.0.1', '1375286455', '127.0.0.1', '1375286455', '127.0.0.1', '', '', '0000-00-00', '', '', '20', '', 'http://127.0.0.3/user/face/'), ('20', '1375286799', '127.0.0.1', '1375286799', '127.0.0.1', '1375286799', '127.0.0.1', '', '', '0000-00-00', '', '', '20', '', 'http://127.0.0.3/user/face/');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
